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

 

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

Message posted via AccessMonster.com


.