Comment box with Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with multiple tabs. In each tab I have a comment box dedicated
for notes. Each time a staff enters a comment about a record, they would
manually type the date. Is it possible somehow to have access generate the
date for that particular note in the comment box? Any suggestions would be
great. Thank you.

Example:

6/18/2005 Spoke with John
6/19/2005 John will be coming to visit the company
etc....
 
John,

Access has a built-in keyboard shortcut Ctrl+; to enter the current
date, which I think would work for you. Otherwise, all I can think of
is to change the structure of the database, so you have the comments
going into a continuous view subform, which is bound to a table with a
date field and a comment field. That means each comment is a separate
record in this table, and this table related many-to-one to your main
table. In this case, you could set the Default Value of the date field
to Date()
 
Back
Top