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.