Changing Currency

S

StuJol

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??
 
A

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
 
R

Roger Carlson

S

StuJol

many thanks alan

Allen Browne said:
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
Click to expand...
 
Top