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.
