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?

Having the time stamp entered before entering a memo forces the user to go to the end of the line of time stamp info, thereby breaking the flow of data entry. If you want to record the time, date and data entry user name......


Put this code on the AfterUpdate event of your memo field.


Dim CurUseRR As String
Dim MemoText As String

CurUseRR = CurrentUser()
MemoText = Me.MemoFieldName

Me.MemoFieldName = CurUseRR & " " & Str(Now()) & ": " & MemoText

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