M
Macsmasher
Hi everybody,
Running Access07
I have a memo field that I will use as a journal. There is a cmd button
that I want to place the curser at the beginning of any existing text, insert
the UserName and date, then place the curser at the end of that new line so
the User can begin typing. The below code works fine with the exception of
placing the curser at the end of the line. Since using SendKeys "{END}" is
never a good idea, I need either something to replace it, or a suggestion on
how to do this differently.
strUser = Forms![frmSwitchboard]![txtCurrentUser] 'Pulling User from main
menu
With Me.memAdminNote
.SetFocus
.SelStart = 0
.SelText = vbNewLine & vbNewLine
.SelText = strUser & " " & Date & ": "
' replace SendKeys "{END}" with what???
End With
Thanks in advance for your input!
-Larry
Maximize Software, Inc.
Running Access07
I have a memo field that I will use as a journal. There is a cmd button
that I want to place the curser at the beginning of any existing text, insert
the UserName and date, then place the curser at the end of that new line so
the User can begin typing. The below code works fine with the exception of
placing the curser at the end of the line. Since using SendKeys "{END}" is
never a good idea, I need either something to replace it, or a suggestion on
how to do this differently.
strUser = Forms![frmSwitchboard]![txtCurrentUser] 'Pulling User from main
menu
With Me.memAdminNote
.SetFocus
.SelStart = 0
.SelText = vbNewLine & vbNewLine
.SelText = strUser & " " & Date & ": "
' replace SendKeys "{END}" with what???
End With
Thanks in advance for your input!
-Larry
Maximize Software, Inc.