converting the digits to indian currency format digit

[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

 

[ruralguy via AccessMonster.com]

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

 

[ruralguy via AccessMonster.com]

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

 

[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

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

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.




.

 

[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?

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]