Comment box with 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....
 
S

Steve Schapel

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()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top