PRB: Upper Report Expression Causes String Too Long to Fit

• Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0, 6.0

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

1. Create a report called Test.



2. Add the Employee table to the Data Environment. The Employee table is in Testdata.dbc located in the \Samples\Data folder.



3. Place the Notes field in the detail band.



4. Double-click the field and open the Format dialog. Check to "To upper case" check box. Close the dialog boxes and save the report.



5. Type the following in the Command window:

   
      REPORT FORM Test PREVIEW 

Additional query words: kbdsd VFoxWin

Keywords : kbVFp300 kbVFp500 kbVFp600 FxtoolReportdes FxtoolRwriter
Version : WINDOWS:3.0,3.0b,5.0,6.0
Platform : WINDOWS
Issue type :