Changing Currency

[Guest]

Is there a way you can change the currency globally. I have several
forms/tables that are in £. I want a combo box on a form to change the
currency globally. Is this possible??

 

[Allen Browne]

No, there's not a global option like that.

In fact, Access does NOT actually store "Currency" where you see Currency in
the Format property. It actually stores *your* currency setting (i.e. the
one from the development machine) and lies to you about what is really
there. The lie is uncovered if you then change your currency setting to
something else: You get to see the literal currency string you originally
had, instead of "Currency".

You therefore have to identify *every* affected control in your application,
and re-assign "Currency" to its Format property in the Open event of every
form and report.

More info:
Currency format does not respect regional settings
at:
http://allenbrowne.com/ser-44.html

 

[Roger Carlson]

I agree. One tool that can help identify all of theys controls is Rick
Fisher's Find and Replace 9.0, which you can find here:
http://www.rickworld.com/download.html

The registered version is much more complete and not very expensive. I use
it all the time.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

many thanks alan

No, there's not a global option like that.

In fact, Access does NOT actually store "Currency" where you see Currency in
the Format property. It actually stores *your* currency setting (i.e. the
one from the development machine) and lies to you about what is really
there. The lie is uncovered if you then change your currency setting to
something else: You get to see the literal currency string you originally
had, instead of "Currency".

You therefore have to identify *every* affected control in your application,
and re-assign "Currency" to its Format property in the Open event of every
form and report.

More info:
Currency format does not respect regional settings
at:
http://allenbrowne.com/ser-44.html