Change currency format in table.

[Chiki]

hi all,

i would like to know whether there is any option,code or formula for
changing the Default currency format from ($) to any other countrys currency.

TIA

 

[Douglas J. Steele]

Access gets its currency symbol from the Regional Settings set through the
Control Panel.

If you don't want to have to change that setting, you can explicitly set the
Format property of the field to something that includes the appropriate
currency symbol.

 

[Chiki]

I m getting a ############################### in my field when i enter the
Format property in the General tab of Format Property for my Amount Field.

i applied the format property as:=Format(Currency,"Yen")

but i m not getting the desired result

Kindly help

 

[Douglas J. Steele]

I'm surprised you're not getting an error: there's no named format "Yen"

What you need instead of "Yen" would be "\¥00.00" (in the event that it
didn't render properly, replace ¥ with the appropriate symbol for Yen)

If it's not appropriate to have two digits after the decimal point, change
to whatever's correct.