Microsoft KB Archive/125047

{| = FIX: @R Displays Incorrect Format in Report Writer =
 * width="100%"|

ID: Q125047

2.5x 2.6x | 2.5x 2.6x | 2.5x 2.60a | 2.60

WINDOWS  | MS-DOS    | MACINTOSH  | UNIX kbtool kbprint kbprg kbfixlist kbbuglist The information in this article applies to:


 * Microsoft FoxPro for Windows, versions 2.5x, 2.6x
 * Microsoft FoxPro for MS-DOS, versions 2.5x, 2.6x
 * Microsoft FoxPro for Macintosh, versions 2.5x, 2.6a
 * Microsoft FoxPro for UNIX, version 2.6

SYMPTOMS
In the Report Writer, if the R character formatting check box is selected for an expression, the expression does not display correctly in Page Preview if the number of characters in the expression do not equal the number of place holders (the character 9) defined in the Format text box.

NOTE: The R character formatting check box places @R in the format string.

WORKAROUND
Define the expression to have the same number of characters as the format defined with the '@R' (without the quotation marks).

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Visual FoxPro 3.0 for Windows.

NOTE: In Visual FoxPro for Windows, select the "Ignore Input Mask" check box in the Format (Field) Dialog Box to prevent this problem from occuring.

Steps to Reproduce Behavior
1. In the Command window, type the following:

myvariable = "1234" USE SYS(2004)+"\Tutorial\Customer" 2. Start the Report Writer and define a an expression called "myvariable" (without the quotation marks) in the Detail band. 3. Choose the Format button. 4. In the Format dialog box, type "9,999,999,999" (without the quotation

marks). 5. Under Editing Options, select the R check box. 6. Choose OK twice to return to the Report Design window.

7. From the Report menu, choose Page Preview.

Note that the format displays a portion of the string and other random characters.

Additional reference words: RWriter VFoxWin FoxWin FoxDos FoxMac FoxUnix 2.50 2.50a 2.50b 2.50c 2.60 2.60a fixlist3.00 buglist2.50 buglist2.50a buglist2.50b buglist2.50c buglist2.60 buglist2.60a KBCategory: kbtool kbprint kbprg kbfixlist kbbuglist KBSubcategory: FxtoolRwriter

Keywords         : FxtoolRwriter kbbuglist kbfixlist Version          : 2.5x 2.6x | 2.5x 2.6x | 2.5x 2.6 Platform         : MACINTOSH MS-DOS UNIX WINDOWS Solution Type    : kbfix
 * }