Move the cursor to the end of the data field

[Phil Chan]

I am using Access 2000 and have a simple form with some
contact info and a note field(memo type). I would like to
have the cursor automatically go to the end of the note
field when the user try to enter/update new info. I found
a setting under tools/options/keyboard/behaviour entering
field but it change everything. I just need to change the
entering behaviour for that memo field only and the rest
is selected entire field.

Thank you so much for your help in advance.

 

[fredg]

I am using Access 2000 and have a simple form with some
contact info and a note field(memo type). I would like to
have the cursor automatically go to the end of the note
field when the user try to enter/update new info. I found
a setting under tools/options/keyboard/behaviour entering
field but it change everything. I just need to change the
entering behaviour for that memo field only and the rest
is selected entire field.

Thank you so much for your help in advance.

Code the Memo control's Enter event:
[MemoName].SelStart = Len([MemoName])