ID: Q108667
The information in this article applies to:
By default, when you open an editing window in FoxPro with the MODIFY MEMO or the @ ... EDIT command, the cursor will be placed at the beginning of the text in the open editing window. Normally you have to press the PAGE DOWN key to put the cursor at the end of the text so that you can start adding more text. To avoid this extra keystroke, you can issue the following code, which automatically places the cursor at the end of the text when you open a memo field for editing.
USE c:\<foxpro main directory>\tutorial\salesman IN 1
MODIFY MEMO notes RANGE LEN(notes)+1, LEN(notes)+1
USE && close database
According to the online help system, the syntax of the RANGE clause for the
MODIFY MEMO command is as follows:
RANGE <expN1>, <expN2>
RANGE lets you open a memo editing window with a range of
characters selected. Characters are selected starting at the
position specified with <expN1> up to (but not including) the
<expN2> character. If <expN1> is equal to <expN2>, no characters
are selected, and the cursor is placed at the position specified
with <expN1>.
Keeping the last statement in mind, the LEN() function is used to evaluate
the number of characters, including spaces, in the memo field. The return
value of the LEN() function is used in both numeric expressions of the
RANGE clause to place the cursor at the end of the text in the memo field.
NOTE: If the memo field is empty, the cursor will be placed at the beginning of the memo editing window.
Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a 2.50b @...edit insertion point KBCategory: kbprg KBSubcategory: FxprgGeneral
Last Reviewed: June 27, 1995