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??