Microsoft KB Archive/100571

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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),' ')

Additional reference words: FoxDos FoxWin 2.50 2.50a 2.50b 2.60 KBCategory: kbprg kbprb KBSubcategory: FxinteropDbase


Last Reviewed: June 28, 1995
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.