Currency Problem

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

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top