General information
Category:
Coding, syntax & commands
Title:
Transform function problems
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only