Access Tip – Time stamp a new record automatically

It is possible to automatically display the date and time of when a new record is being created in Microsoft Access by following the below steps:

  • In the Navigation Pane on the left hand side, right-click the table that you want to change and click on Design View.
  • Select the field that you want to change and make sure its data type is set to “Date/Time”
  • On the General tab, type the function “Now()” into the Default Value property box.

Share this tip on