Microsoft KB Archive/156642

= 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

-

APPLIES TO


 * 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.



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 </li></ol>

Additional query words: kbdsd VFoxWin

Keywords: KB156642

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.