Date and Time Stamp for Notes feild

[Mreid99]

I would like to have note commented by an autofeild(of date/time), when someone enters new notes in the database, it will be updated by a date a time, the notes are only added to, not over written.

 

[bitbrain]

You can give a (table's) text field a default value of Date() or Time(). Each time a row is added the field will default to date/time - it won't work for updates (add code to a form's BeforeUpdate event to do this).<br>
<br>
You will need separate fields for date and time.

 

[elizabeth]

FYI, the now()function includes both date & time. Also if you update it - Forms!FormName!FieldName = now() in the BeforeUpdate event, there's no need to specify it as the default.