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" wrote:

> How about: Format([YourField],"##,##,##,##0,00")
> ...or some version of it?
>
> Irshad Alam wrote:
> >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
> http://www.accessmonster.com/Uwe/For...dules/201001/1
>
> .
>