Can I start my 'notes' field with current date & time followed by the current
user? Please advise. I am a new beginner and I don't understand much about
the expressions and macro. Thanks.

Current Date/Time is the Now function.

Current user, it depends on your definition. If you're using Access
security, and want their Access login name, you use CurrentUser(). If you
want their Windows login ID, check
http://www.mvps.org/access/api/api0008.htm at "The Access Web"

How you put these values into the field depends on how your form works. You
could put logic in the form's Current event to set the notes field. Assuming
the name of the textbox that's mapped to the Notes field is named txtNotes,
you could use something like:

If Len(txtNotes & "") = 0 Then
txtNotes = Now & " " & fOSUserName() & ": "
End If

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Jowen" <(E-Mail Removed)> wrote in message
news:514C30D1-26C6-484F-863E-(E-Mail Removed)...
> Can I start my 'notes' field with current date & time followed by the
> current
> user? Please advise. I am a new beginner and I don't understand much
> about
> the expressions and macro. Thanks.