>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

You need a space between $ and 9.