Can i define my own currency symbol

[shalskedar]

Can i define my own currency symbol....

I need to maintain money value in my db as different from the standard ones as listed in the Format option..

Does Ms Access provide with any such utility..

[ADezii]

How, exactly, would you like your Money Values stored?

[shalskedar]

For ex- RM 120,RM 3000,RM 45.65..Should be starting with RM

[ADezii]

What do 120. 3000, and 45.56 represent?

[shalskedar]

Represents values for the column Sales tax in the table .Can i change the currency symbol $(standard) to RM(i.e user defined)...

[ADezii]

I don't think that this can be done within Access, but a real Shot-in-the Dark is:

1. Control Panel
2. Regional and Language Options
3. Format Tab ==> Customize this Format
4. Currency Tab ==> Currency Symbol (change to 'RM')

[NeoPa]

That's pretty well the size of it I should think, though a viable alternative might be simply to include this text in the formatting of any of your currency values. A format string would be something like :

#,##0.00 RM

[hazel benj]

"RM "#,##0.00 <-------- place this on format of your
currency