I am new to Access. I am familiar to fox pro
In Access report How can I format currency like
12,33,450.00
I had used format() but it groups in 3 digits.
I have even changed regional setting digit grouping to 2
even then it doesn't helps.
In fox pro there is function Transform() by which desired result can be obtained
Is any such function available in Access or vb
or any code to be written for this
Please help

civa

If memory serves correct (which seeing as I am at midnight it probably doens't!!)

myNumber = format(myNumber, "##,##,###.##")

Or some derivative of that.

HTH

Mike

Mike
EchoVue.com

i have tried doesn't works groups in 3 digits

civa

Try this:

&&\,&&\,&&&\.&&

I'm not familiar with this currency format- but this will have a group of three to the left of the decimal, followed by a group of two, followed by a group of (the rest of the numbers).

Phil.