Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Access
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Show current date and time
 
  1. Open the form or report in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.).
  2. On the Insert menu, click Date And Time.
  3. To include a date, select the Include Date check box, and then click a date format.
  4. To include the time, select the Include Time check box, and then click a time format.

Note  Microsoft Access adds two text boxes (text box: A control, also called an edit field, that is used on a form, report, or data access page to display text or accept data entry. It can have a label attached to it.), one to show the date and another to show the time, to the form or report and sets their ControlSource property to an appropriate expression. If there is a form or report header (report header: A report section that is used to place information (such as a title, date, or report introduction) at the beginning of a report.), Access adds the text boxes to that section. Otherwise, it adds the text boxes to the detail section (detail section: Used to contain the main body of a form or report. This section usually contains controls bound to the fields in the record source but can also contain unbound controls, such as labels that identify a field's contents.). You can move, size, or position the text boxes and set their properties to customize their appearance.

advertisement