Lock scroll bar

[NachoMan]

Does anyone know if it is possible to lock the scroll bar in a memo field? I have a form with a memo field in which the user types a (at times) lengthy transcript. When the focus leaves the memo field and the user then returns to that memo field, the cursor is placed at the beginning of the field and the scroll bar goes back to the top. Is there a way to lock the scroll bar on Lost Focus so that when the user returns to the field, they can continue where they left off and not have to scroll back and find where they left off. This is necessary because the user often has to leave and make changes to that field when creating transcript records. Not super critical , but a hassle nonetheless. Any help, hints would be great. Thanks.

--Lou

 

[Mile-O]

Or, even easier,

Private Sub MyText_Enter()
    Me.MyText.SelStart = Len(Me.MyText)
End Sub

 

[NachoMan]

Alright!

Good man, Mile. This does exactly what I needed. I just assumed I had to focus on the scroll bar. What a narrow horizon I operate on! I will definitely be studying up on my string functions more. Thanks again.

-Lou