Formatting currency

[Alain]

Hi to all,

I am wondering if there is a way to programmatically format a currency
symbol depending of the country of origin.
like the euro, britihs pound, kuwaiti dinar, russian ruble.
I have develop a small db for a client and he would like to have the proper
symbol attached to the curency
I have look around but not being able to find anything

Thanks

Alain

 

[Allen Browne]

Unfortunately, Access does not really store "Currency" as the format, but
rather stores the currency setting of the developer, as described in this
article:
Currency format does not respect regional settings
at:
http://allenbrowne.com/ser-44.html

The workaround suggested in that article might address your issue.

 

[Alain]

Thanks Allen

Unfortunately, Access does not really store "Currency" as the format, but
rather stores the currency setting of the developer, as described in this
article:
Currency format does not respect regional settings
at:
http://allenbrowne.com/ser-44.html

The workaround suggested in that article might address your issue.