Changing dynamically the format of a currency field " Price"

[ManuelLavesa]

Ideally on the invoice Report I am trying to change the currency field (Price) depending on the customer country. Is there a way of doing this? Also Access seems to only have $ and euros... Is there a way of adding other currencies such as pounds or CHF? Thank you for your help

[ranman256]

in the table , remove the dollar sign in the format of the currency field
then in the country table, youd have
tCountryCodes
-----------------
countryCode, currencyCode, currencySymbol
JPN, YEN,¥

join your table to the tCountryCodes on CountryCode
then use the symbol.

[ManuelLavesa]

Thank you for your answer... But I have to say that I am new at this so I don't know how to remove the dollar sign. I know how to change the format to euros or currency. The currency format is in $. Could you please explain it a little bit more about how to do it. Thanks.

[ManuelLavesa]

I have been looking in the internet and I found some suggestions but do not work. So this is what I tried I went to my table Products in design view. Then I picked the field that has the currency format (Price) and in the format box I erased the currency word and replaced it with CHF#,##0.00 The system converts this to /chF#,##0.00 and when I save the table and look at the data sheet. I see that the change is very strange I get C0F#,##0.00 and C10F#,##0.00 and many other combinations but not CHF. Does anybody know what am I doing wrong?

[NTC]

well R256 offers great advice but in this case I don't think one can remove the currency symbol as a table property. Though I welcome input on that to learn something new. I know one has that option in excel.

I believe that you need to option the currency field instead to be a generic single number field - and add a field that holds the currency ID. Then with this currency ID field you would either simply use it instead of the symbol i.e. USD or CHF or whatever - or use it to dynamically toggle visibility of the correct currency symbol image with is a little more tricky. Just off the cuff.