Insert the date and time into a report or form

  1. Open the Access report or form in Design view or Layout view.

  2. On the Design tab, in the Header / Footer group, click Date and Time. Note, if you're using Access 2007, click Date and Time in the Controls group.

    The Date and Time dialog box appears.

  3. Clear the Include Date check box if you do not want to include the date.

  4. If you want to include the date, click the date format that you want to use.

  5. Clear the Include Time check box if you do not want to include the time.

  6. If you want to include the time, click the time format that you want to use.

    A sample of the date and time information in the formats you have chosen appears in the Sample area of the dialog box.

  7. Click OK.

    The date and time information is added to the report or form.

Note: On a form, the date and time fields show the system date and time at which that the form was opened. On a report, the date and time fields show the system date and time at which the page containing the fields was printed or previewed.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×