Automatic Date Entry Memo Field

[mercwonder]

I have a memo field on a form. I am trying to autopopulate it when entered into. For example: I enter in clients info and then tab to the memo field and it automatically enters date and time. Then later when I go back to that same record to append to the memo field it adds the current date. This way I can go back and see all the dates and times when that person called. Any idea how to do this? Thank you

 

[Bodisathva]

[memofield]=[memofield] & "|" & now()

adding the current time to the existing field data will enable you to retain previous entries....the pipe is just a delimiter

 

[mercwonder]

Thank You

That worked out perfectly, thank you. When It enters the date it is selected. Is there a way to have it enter the date and time and then return to the line underneath it? (Like hitting enter in word to create another paragraph.)
ex. I tab into the memo field and it enters the date and then places my curser below the date so I can enter my notes?

 

[Bodisathva]

[memofield]=[memofield] & "|" & now() & vbcrlf

vbcrlf = VB-Carriage-Return-Line-Feed

 

[mercwonder]

When I tried, it didn't work it still keeps it highlited

Here is the code I used: memo=memo & Now() & vbCrLf

When I tab into the field it only leaves it selected... Any ideas?

 

[Bodisathva]

when the text is highlighted, press the right arrow to go to the end of the highlighted text, which is where you want to be.