converting the digits to indian currency format digit

  • Thread starter Thread starter Irshad Alam
  • Start date Start date
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
 
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
Click to expand...

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


.
Click to expand...
 
Back
Top