converting the digits to indian currency format digit

I

Irshad Alam

I have the figure as below in one of my form field/and in report:

23,125,456.48

I want to display in indian currency format :

2,31,25,456.48

Any help, ugently requrired.

Regards

Irshad
 
R

ruralguy via AccessMonster.com

How about: Format([YourField],"##,##,##,##0,00")
...or some version of it?
 
R

ruralguy via AccessMonster.com

Adding in the decimal as I should have:
How about: Format([YourField],"##,##,##,##0.00")
 
I

Irshad Alam

sorry, it does not work, i used as below :

Private Sub Label4_Click()
Me.Text2 = Format([Text0], "##,##,##,##0,00")
End Sub


Any other solution.

Regards

Irshad


ruralguy via AccessMonster.com said:
How about: Format([YourField],"##,##,##,##0,00")
...or some version of it?

Irshad said:
I have the figure as below in one of my form field/and in report:

23,125,456.48

I want to display in indian currency format :

2,31,25,456.48

Any help, ugently requrired.

Regards

Irshad

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.




.
 
R

ruralguy via AccessMonster.com

Did you use the decimal as my post suggests?
Me.Text2 = Format([Text0], "##,##,##,##0.00")

When you say it did not work, what did you get?

Irshad said:
sorry, it does not work, i used as below :

Private Sub Label4_Click()
Me.Text2 = Format([Text0], "##,##,##,##0,00")
End Sub

Any other solution.

Regards

Irshad
How about: Format([YourField],"##,##,##,##0,00")
...or some version of it?
[quoted text clipped - 12 lines]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top