>I have 2 fields in a SQLServer table defined as money and a form that uses that table to view the data.
>
>The problem I have is the field always shows 4 decimal places in the form. I tried using format to get it to show in a normal currency way. $999,999.99
>After no success I added 2 properties to the for and am trying to use transform to get that data in the correct format.
>
>In thee init and refresh I have this code:
>
>WITH thisform
> .IntVal = TRANSFORM(v_stands.dIntValue, '@B$999,999.99')
> .TimbVal = TRANSFORM(v_stands.dStdTimVal, '@B$999,999.99')
>ENDWITH
>
>When I use this with the inputformat of the text box I end up with a mess. So I took everything out of the textbox and am trying to do it with the transform.
>
>What is showing up on the form is $1888.6600
>
>Any help would be appreciated.
>
>Thanks
>
>Quinn
Try with
alltrim(TRANSFORM(mon, "@Z $999,999,999,999.99"))
If it's not broken, fix it until it is.
My Blog