David,

I use left-justified mono-spaced output for financial reports.

The only other possibility is to drop several controls on the report band for each figure, which is more work than I care to do, but might go like this:

1. A "$" sign
2. An open "(" with print when MyTable.MyValue < 0
3. The value, ABS(MyTable.MyValue)
4. A close ")" also with print when MyTable.MyValue < 0

This would get you out of the mono-spaced font, but of course makes laying out reports a big headeache.


>
>Kenneth, your little UDF works great...for left justified fields. Turns out I'd like to right justify the field of interest. Apparently, VFP is just as happy as a clam to squeeze white space out of the right side of character strings to be printed and right justified. And it does just that to the output of your UDF. (At least I assume that's what's happening since the ')' of the negative values aligns with the LSD of the positive values ... but only when I right justify).
>
>Do you know of a character that prints as a space but is not interpreted as 'whitespace' by VFP.