PRB: dBASE III+ Memo Fields Display Box Characters in Report

ID: Q100571

The information in this article applies to:

• Microsoft FoxPro for Windows, versions 2.5, 2.5a, 2.5b, 2.6
• Microsoft FoxPro for MS-DOS, version 2.6

SYMPTOMS

The FoxPro for Windows Report Writer displays box characters where word wraps occur in dBASE III PLUS or FoxBASE+ memo fields. These characters do not appear in FoxPro for MS-DOS.

CAUSE

The box character is ASCII code 141. The character appears as a thick vertical line when you are editing the memo field.

RESOLUTION

To remove these characters, issue the following commands:

   USE <database name>
   REPLACE ALL <memofld> WITH STRTRAN(<memofld>,chr(141),' ')

Last Reviewed: June 28, 1995