G
Guest
Hi all,(sorry for posting this question before in the wrong group)
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 (euro in my case).
So running the form the form field 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)(or i
change my regional settings on my computer). Now 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????)
Am i wright, Is there a way to do this 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 (euro in my case).
So running the form the form field 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)(or i
change my regional settings on my computer). Now 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????)
Am i wright, Is there a way to do this correctly ?