If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change currency format in table.
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 |
#2
|
|||
|
|||
Change currency format in table.
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. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Chiki" wrote in message ... 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 |
#3
|
|||
|
|||
Change currency format in table.
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 |
#4
|
|||
|
|||
Change currency format in table.
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. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Chiki" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|