PRB: Upper Report Expression Causes String Too Long to Fit

 Last reviewed: January 10, 1997
Article ID: Q156642
The information in this article applies to:
  • Microsoft Visual FoxPro for Windows 3.0, 3.0b, 5.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

KBCategory: kbtool kbprb
KBSubcategory: FxtoolRwriter FxtoolReportdes
Additional reference words: 3.00 3.00b 5.00 kbdsd VFoxWin



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 10, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.