Displaying Date in Notes

[Charles L. Phillips]

Hello,
I have a field called "Notes", how can I get the date to automatically
display in this field, after an entry...

 

[Gary Miller]

Charles,

Use the Date() function in the DefaultValue Property of the
Form.

DefaultValue = Date()

This works for new entry stamping of the Current Day. For
modifications you generally need a VBA code line or two.

I am curious about storing this in the 'Notes' field. You
should normally store this in something like a NoteDate
field that is of a Date/Time data type.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________