Knowledge Base

You receive the "String too long to fit" error message after you change the format of a memo field to uppercase in Visual FoxPro

Article ID: 156642

Article Last Modified on 2/12/2007

Microsoft Visual FoxPro 3.0 Standard Edition
Microsoft Visual FoxPro 3.0b Standard Edition
Microsoft Visual FoxPro 5.0 Standard Edition
Microsoft Visual FoxPro 6.0 Professional Edition
Microsoft Visual FoxPro 7.0 Professional Edition
Microsoft Visual FoxPro 8.0 Professional Edition
Microsoft Visual FoxPro 9.0 Professional Edition

This article was previously published under Q156642

SYMPTOMS

After changing the format of a memo field to upper case in the Report Writer, the error "String Too Long to Fit" appears when attempting to print or preview the report.

CAUSE

The Report Writer's expression builder cannot convert fields larger than 256 characters to upper case. You must use the UPPER() function to convert those fields.

WORKAROUND

In the Report Expression box for the field, use the UPPER() function to transform the memo-field contents to upper case.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

Create a report called Test.
Add the Employee table to the Data Environment. The Employee table is in Testdata.dbc located in the \Samples\Data folder.
Place the Notes field in the detail band.
Double-click the field and open the Format dialog. Check to "To upper case" check box. Close the dialog boxes and save the report.
Type the following in the Command window:
```
   REPORT FORM Test PREVIEW
						
```

Additional query words: kbdsd VFoxWin

Keywords: KB156642