How can I changed currency format

bpankaj35

New member
Local time
Today, 15:45
Joined
Jun 30, 2012
Messages
2
Hi I have created access database having field currency but it shows currency in $ by default I want to changed it to Rupee. Plz help me How could it do?
Thanks
Pankaj
 
Use a Format string.
Precede characters you want literal with a backslash.

If you are happy with "Rs" and a comma after each three digits then it would be:
Code:
Format(whatever, "\R\s#,###")

If you need a special character then let a string variable to that character and use it in the Format like this:
Code:
Format(whatever, "\" & strChar & "#,###")

The variable can be let from the Hex code using
Code:
strChar = ChrW(&Hxxxx)
(where xxxx is the hex value)

However if the system does not have the character it will display it as a question mark.
This page gives the hex code but it didn't work for me in Australia.
It might work for you in India.
 

Users who are viewing this thread

Back
Top Bottom