Indian Currency

[nithubp]

Hi All,


have to generate reports (totals) in Indian Currency which is making me mad after trying couple of possibilities such as windows regional settings and called a function. Its not working



Can someone help me on this !!

[thhui]

To workaround, use vba function to format the currency instead.

INR
Rs
Re
Rupee

The new unicode symbol Rupee, however, still not work now.

[aamer]

You Can Use the Following in the property of Totals Text Box In Format Property

"Rs. "#,###.00;"-(Rs. "#,###.00);0.00
Try This Also:
"Rs. "#,###.00[Blue];"-(Rs. "#,###.00)[Red];0.00[Black]

[nithubp]

thanks !!
I tried these formats it does not take for two digits , it still returns values for eg:Rs. 3,432,432,423.00

[aamer]

You Can Use the Following in the property of Totals Text Box In Format Property

Change Decimal Places Value From Auto Or 0 to 2

[krag]

I think the original question is about formatting the indian currency to the system of thousand, lakh, crore and not about decimal places. 123,456,789 in western currency would be 12,34,56,789 in Rupees. I am also looking for a format do this and if someone has got it, please advise. I tried "Rs. "##,##,##0 but it does'nt work.
The other issue is the new symbol for rupee which is available in currency setting in excel but not in access 2013. I cannot use the unicode U+20B9 in the currency property directly and need to develop a VBA code.

[krag]

Just now I set up the database in english version from Japanese version. After setting the region setting for digit grouping and currency symbol (new rupee symbol was available), both problems are solved.