R
Rli
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 ?
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 ?