Changing Regional Setting Behavior within access

[Guest]

Hello, I have an Access 2003 application that is currently being used from my
United States clients. Soon, a UK client is going to start using it though
Citrix. They have their regional settings though Citrix set as English
(United Kingdom). It's not an option to change their regional setting on
Citrix as they use another Access application that needs to have United
Kingdom settings.

All the amounts in the my system are in U.S. dollars but the application
will show them as Sterling for the client using Citrix. Is there a way to
the access application override the regional settings and show the currency
as U.S. dollars? Or do you have to go into each screen and report, change
the datatype from currency and format it as a string with the '$' sign in
front?

Thanks

 

[Joseph Meehan]

Hello, I have an Access 2003 application that is currently being used
from my United States clients. Soon, a UK client is going to start
using it though Citrix. They have their regional settings though
Citrix set as English (United Kingdom). It's not an option to
change their regional setting on Citrix as they use another Access
application that needs to have United Kingdom settings.

All the amounts in the my system are in U.S. dollars but the
application will show them as Sterling for the client using Citrix.
Is there a way to the access application override the regional
settings and show the currency as U.S. dollars? Or do you have to go
into each screen and report, change the datatype from currency and
format it as a string with the '$' sign in front?

Thanks

I think there may be a way of doing exactly what you want, but I am not
sure.

Likely I would just provide my own '$' and either turn off the indicator
in Access or change the field type to a number field not currency.