Currency symbol question

G

Guest

Hi all,
I am having trouble with my form fields with currency format.
When one chooses "currency" in the format property of a field it pics up the
regional settings of windows (with is euro in my case).
Running the form the formfield shows 1,00 € for instance.

Now i save the form and quit the database and transport this database to
another computer with different regional settings (dollars for example) i
would like the database to pic up automatically those settings and display
the form field as 1.00 $

But it does not....when saving the form on the 'euro'machine the format
property is actually saved as
#'##0.00 €;-#'##0.00 €
so hard coding the euro-sign (but the decimal comma is automatically changed
in a dot however?)

Is there a way to do ithis correctly ?
 

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

Similar Threads

Currency symbol question 6
export to XL - problem with currency format from cells 1
custom currency symbol independent of regional settings 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
format property is being modified 5
Enable user to change currency format 1
Why only one Current event for continuous forms? 9
Currency is Not working 8

Top