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