Currency Problem

  • Thread starter Thread starter Roody Senecal
  • Start date Start date
R

Roody Senecal

I would like my forms and reports to change currency
automatically when I change the computer setting. When I
change a text format to Currency, when the form first
load the currency change, but after that if I again
change the computer setting, it does not change back. Can
someone help.
 
Yes, it appears that although Access displays the word "Currency" in the
Format property of a field or control, that is not what it stores. Instead,
it seems to hard-code the developer's currency setting into the control and
just display Currency. The lie is discovered when you change your Regional
Settings.

A workaround is to use the Open event of each form and report to set the
Format property of each affected control to Currency. This forces Access to
interpret the currency setting of the end user, rather than using the
original currency settting of the developer.

Haven't tested it, but I have wondered if you programmatically set the
Format property to the word Currency in design view, whether this would
bypass the problem that occurs when the Format is set through the interface.
 
Back
Top