Article ID: 137948
Article Last Modified on 2/2/2005
APPLIES TO
- Microsoft Visual FoxPro 3.0 Standard Edition
- Microsoft Visual FoxPro 3.0b Standard Edition
This article was previously published under Q137948
SYMPTOMS
When a numeric field or variable is added from the Controls toolbar, the field is formatted to be left-aligned (left-justified).
WORKAROUND
To return to the behavior observed in FoxPro for Windows 2.6, either delete the '@B' from the format template box or select the three-dot button after the Format box and clear the Left Justify check box from the Editing Options in the Format dialog box.
NOTE: In FoxPro for Windows 2.6, if the data type was changed to numeric, the Left Justify check box was disabled (grayed out).
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem has been fixed in Visual FoxPro 5.0 for Windows.
MORE INFORMATION
If the field is dragged from the data environment or added with the Quick form option, it aligns correctly.
Steps to Reproduce Problem
- Create or modify a report.
- Click the Field control button on the Controls toolbar, and add the field to the report.
- In the Report Expression dialog box, click the three-dot button after the Expression box.
- In the Fields box, double-click the name of the field in Fields list or the variable in the Variables list.
- Click OK.
- In the Report Expression dialog box, click the three-dot button after the Format box.
- In the Format dialog box, ensure that the data type selected is Numeric.
- Enter 999,999 (for an example) in the format template box.
- Click OK two times to return to the Report.
- Preview the report. Notice that the numeric fields are now left-aligned (left-justified). Close the preview.
- Double-click the Field control. The Format template box will now have an @B 999,999. The "B" is the Picture clause indicating it has been left-aligned.
- Choose the three-dot button after the Format box. Look at the Editing Options. The Left Justify box is now checked.
REFERENCES
Visual FoxPro for Windows "User's Guide," version 3.0, Chapter 9, "Designing Reports and Labels."
Additional information can be found by searching for "Format Template" and @...SAY in the Visual FoxPro Help file.
Keywords: kbbug kbfix KB137948
