How to Place a Carriage Return in a Memo Field in FoxPro

ID: Q92358

The information in this article applies to:

• Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, 2.5a, and 2.5b
• Microsoft FoxPro for Windows, versions 2.5, 2.5a, and 2.5b

To place a carriage return in a memo field using the REPLACE WITH command, the string must contain the ASCII code for the carriage return.

For example, to place the following data in the "notes" memo field

   TEXT
   TEXT2

   REPLACE notes WITH "TEXT"+CHR(13)+"TEXT2"

NOTE: In FoxPro 2.5b, this code does not work if the contents of the memo field is copied to a text file and then opened in Notepad.

Additional reference words: FoxDos FoxWin 2.00 2.50 2.x CR 2.50a 2.50b KBCategory: kbprg KBSubcategory: FxprgGeneral

Last Reviewed: June 27, 1995