How do you handle globalisation for currency fields?

[Guest]

What is the best way to handle currency fields for use with different
language versions of Access?

I know this is a problem when setting it at design time...

Will myCtrl.Format = "Currency" work for non-english language versions?

Steve

 

[Guest]

My guess is that it should work. VBA is only available in English as far as I
know so setting the currency would set it right. I use the dutch version and
also use: format, standard, fixed etc because VBA won't understand Dutch
anyway.

hth

 

[Guest]

Thanks for the reply.

The problem is this is just setting a form property...
In your version, would you still set the property to Currency even though
the from designer field descriptions ar in Dutch?

I wondered if vbCurrency may work when doing at run-time?

Steve

 

[Guest]

steve,

That option would set the currency to Euro's in my case but that's because
the windows settings are set to euro's.

hth