I'm having a hell of a time trying to get VFP to print my money fields the way I want them.
Currently, all of my money values are stored as numeric.
What I desire is:
a) Floating '$' directly to the left of the value
b) Surrounded by parentheses if negative
c) No space between the '$' and the left parenthesis when number of digits is less than the maximum.
d) Always a zero to left of point if amount is less than 1 dollar.
e) Commas at every third digit.
f) In this case, a maximum of 6 numeral digits to the left of the point.
The following two things yeild the same result and don't work
TRANSFORM(myval,"@($$$$,$$9.99")
TRANSFORM(myval,"@(@T$$$$,$$9.99")
Both of the above put space between the $ and ( and neither prints commas at all??
"The Iron Fish: The water is cold...but the fish don't mind"
...Jay Jenks, boyhood chum