Prices format

[stonda]

If price are more than 999,99 euros, the format is 1,000.00 €. I would like to cancel the comma to get 1 000.00 €. How can I do this ?

[Duncan Rounding]

I would suspect this is part of catalog.exe (hard coded) or/and some perl scripts. Norman may know about it - else perhaps support could comment on this one.

[los_design]

could be a nice addition to the wishlist?

Have a seperator selection within the settings | business settings | options

[leehack]

Outside chance of a formatted field in access? stretching it i know...but maybe lol.

[los_design]

Outside change of a formatted field in access? stretching it i know...but maybe lol.

good call Lee,

[stonda]

So I will wait for Norman or Actinic support !
Thanks

[leehack]

Norman comes on here in his own time, when he feels like it Didier, you don't wait for him at all, he is an actinic user, just like you. If you have a support contract, i suggest you contact actinic and use the facility.

Alternatively, have you looked into the database to see if the formatting occurs in there or you waiting for someone to do that for you?

[stonda]

Lee, as Duncan supposed that Norman could have an answer, I propose to wait for Norman, but it's only a joke.
I do not check into the database, as my knowledges are too poor for this !

[Duncan Rounding]

Norman is lazing in the Turkish sun at this time of year so he may not see this thread. If he doesn't then it may be better for you to ask support.

[stonda]

Thanks Duncan, I will do. Happy Norman !

[stonda]

I get the answer from Actinic Support, if it can help :
"Open the database and open the table [currencies], then in the
'SMONTHOUSANDSEP' column for the 'Euro' record, remove the comma, and close
the database.
When you open the software the comma separator will be removed."