dmccs
10-30-2001, 08:57 AM
I would like to have the time stamped on the next available line of the memo field on my form and then advance to the next line so that the user may start typing text.
eg...
10:00:00 am
"User text here"
Any help provided, would be greatly appreciated.
Travis
10-30-2001, 11:40 AM
Try this:
Me.Text0 = Me.Text0 & vbCrLf & Now() & " "
Me.Text0.SetFocus
Me.Text0.SelStart = Len(Me.Text0)
dmccs
10-30-2001, 11:50 AM
Thank you for the idea. The problem with this is that it erases previous entries and simply puts the date in. Any other ideas?
Alexandre
10-31-2001, 12:57 AM
Travis ' solution should do for you if you use the code in the On Enter event of your control. Another way would be to grab the text in the control, append the date stamp using Travis' indication and repaste it into the control (for example using the After Update event):
Me.Text0 = Now() & " " & vbCrLf & Me.Text0.text
Alex