Memo Field - Positioning the Cursor 1

[LarryDeLaruelle]

I have a memo field on a tab control.

When the user clicks on the 'Notes' tab, I would like the cursor to be placed at the end of the existing entry/ies so the user can begin typing the next entry.

Currently, it highlights/selects the entire entry and, of course, the first key stroke deletes the selection.

Is there a simple (or even a not-so-simple) solution to this?

Using Access 2K.

Thanks.

Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[BillPower]

Hi LarryDeLaruelle,

This should work ok for the On Got Focus event of the MemoField:
On Error Resume Next
Me!MemoField.SelStart = Len(Me!MemoField) + 1

Bill

 

[LarryDeLaruelle]

Bill:

Thanks again. That did the trick.

I had thought that there was a property that could be set to do this. Was I dreaming or was it in Access97?



Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[ptpaton]

Larry,

you may be thinking of the option to go to the start of the field via the keyboard. That's found under Tools>Options>Keyboard Tab and selecting Goto Start of Field under Behavior entereing field.

Sound right?

-Patrick

Nine times out of ten, the simplest solution is the best one.

 

[LarryDeLaruelle]

Patrick:

Thanks, that was it.

I had thought there was a property such as that which could be set for individual controls.

Guess not; however, Bill's solution works perfectly.


Larry De Laruelle
ldelaruelle@familychildrenscenter.org