Memo Field

[mrssevans]

I am trying to enter this code and it works, but I am needing some code to make this enter at a certain point in the notes field. I need it to go to the beginning of the notes field because there are notes in the field already, enter code:
Private Sub Notes_Entry_Click()
Me.Notes = Me.Notes & "***" & CurrentUser() & "***" & Now()
End Sub
and then put a space below it. Can anyone help?

 

[mjdavie]

Try selecting options from the menu then select the keyboard tab and choose 'Go to Start of Field' in the Behaviour entering field option.

this should do the trick

 

[mrssevans]

I could use this but I am afraid that with the critical information that we have stored in these fields that it will over right the current information is something messes up. Any other suggestions?

 

[Jack Cowley]

See my post to your question in the VBA section. Please post your question in only one place....