>I checked these suggestions from curiosity, nothing else. I have come to the following conclusions:
>
>1) the transform(x, "$999,999") and variants aren't actually making VFP print in currency format. The $ is being reproduced as a literal. This may (or may not) be why you get the .00.
>
>I think the correct format for what you want is
>
>>Transform(x, "@Z$ 999,999")
>
>Note the space -after- the $ sign.
>
>Actually, I have a small advantage: when I print currency, I get a £ (pound) sign if it works. Your formats gave me a dollar sign, indicating the literal.
>
>Hope this isn't too late!
>
>MSS
You may be on to something, but it's not quite treated as a literal. If I substitute the letter "Q" for the "$", I do not see the Q at all with "@ZQ 999,999,999" but I do see it with "@Z Q999,999,999", at the extreme left of the output. Another oddity is today, I don't see the ".00" at all and the number is formated correctly with all ",", etc that appear in the string. Very strange, but there does seem to be something related to just the "$" or currency indicator. Phase of the moon? < g >