Updating a memo field after Date and Time Stamping 2

[Szigeti]

When I use a “date stamp” button for updating a memo field, I get the date and the time but after clicking the button I must click in the memo field so the courser will be ready to record what the operator will type. I would like to eliminate the second operation of having to click a second time in the memo field. I thought of using the
SendKeys “{Down}”
But Access highlight all the existing memo, rather then simply for the courser going to the last spot in the memo.

I will appreciate any ideas

 

[jimmythegeek]

Put this code on the click of your date button (change the red fields to the name of your memo field):

==========
Application.SetOption "Behavior Entering Field", 2
If IsNull(Me.MemoFieldName) Then
Me.MemoFieldName= Now() & " "
Else
Me.MemoFieldName= Me.MemoFieldName& vbNewLine & Now() & " "
End If
Me.MemoFieldName.SetFocus
Application.SetOption "Behavior Entering Field", 0
==========
Jim Lunde
compugeeks@hotmail.com
Custom Application Development