Microsoft KB Archive/88603

= BUG: Calculated Currency Field Ignores Formatting =

Article ID: 88603

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 5.0a
 * Microsoft Visual FoxPro 6.0 Professional Edition
 * Microsoft FoxPro 2.0
 * Microsoft FoxPro 2.6 for MS-DOS
 * Microsoft FoxPro 2.6a Standard Edition
 * Microsoft FoxPro 2.6 Standard Edition
 * Microsoft FoxPro 2.6a Standard Edition

-



This article was previously published under Q88603



SYMPTOMS
If a Picture clause on an @...SAY command specifies a format for a currency field, this formatting may be ignored when the output is calculated. For example, if the Picture clause is $999.99 and the calculated output is $123.2342, all decimal places are displayed.



CAUSE
This problem occurs if the @ sign is used in the Picture clause.



RESOLUTION
Remove the @ sign from the Picture clause.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.



Steps to Reproduce Problem
Run the following code: x = 123.1111 @2,2 SAY x PICTURE &quot;@$999.99&quot; Note that the result is $123.1111 instead of $123.11.

Additional query words: picture say kbvfp500 kbvfp600

Keywords: kbbug kbprogramming KB88603

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.