Show All

Display four-digit years in all fields and controls containing dates

You can ensure that Date fields and controls display four-digit years, even if the Format property settings for individual fields and controls specify dates with two-digit years.

1. On the Tools menu, click Options, and then click the General tab.
2. Under Use four-digit-year formatting, do one of the following:

   To display four-digit years in the current Microsoft Access file, select the This database check box.

   To display four-digit years in all Access files, select the All databases check box.

Note  Selecting one of these check boxes only changes how dates are displayed— it does not change the data itself.