Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transform
Message
From
22/12/2000 16:15:57
 
 
To
22/12/2000 12:45:39
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00455636
Message ID:
00456476
Views:
37
>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 >
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform