Time Stamp a Memo Field

[mrssevans]

I am wanting to timestamp and userstamp a memo field each time before the user start typing in the field. It would Look like
***User***Date***Time***
I have tried to do this in a macro but it is faulty.
Does anyone have any suggestions?

 

[jwindon]

I answered your question in the Macros thread.

 

[R. Hicks]

If you want it in the format you are showing in this thread ..... then try:

Private Sub YourMemoTxtbox_AfterUpdate()
Me.YourMemoTxtbox = "***" & CurrentUser() & "***" & Format(Date, "mm/dd/yyyy") & _
"***" & Time() & "*** " & Me.YourMemoTxtbox
End Sub

(Change the control names above to the names of your controls)

RDH

[This message has been edited by R. Hicks (edited 11-15-2001).]