Automatic update to date/time fields?

Dear Gail

Thank you for attending Access and Excel Courses!! I hope you enjoyed the courses and benefited from them.

This is quite simple.

1. Go to the table design view.

2. Click on the field where you want the updated date. Make sure the Data type is set as Date/Time

3. In the field Properties click where t says Default Value and type in =date()

4. Click on the field where you wan the time to be updated automatically. Ensure that the data type is set to Date/Time

5. In the field Properties click where it says Default Value and type in =time()

6. When you go to the datasheet view you'll be able to see the new record will have the date and time will automatically appear

Normally the default values on an existing field gets copied over if you create a form based on this table.


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007