totn Access

MS Access 2003: Popup Calendar in a form/subform

This MSAccess tutorial explains how to create a popup calendar in a form or subform that is linked to a text box in Access 2003 (with screenshots).

Question: I'm using Access 2003/XP/2000/97, can you explain to me how to create a popup calendar in a form and also how to create a popup calendar in a subform?

Answer: There are may different ways to code popup calendars. We've provided a download to demonstrate how popup calendars work in both forms and subforms.

Download version in Access 2000

Download version in Access 2002

Popup Calendar in a Form

Here's what we mean by a popup calendar in a form. Below is a form that has a date of birth field.

Microsoft Access

When the user clicks on the button to the right, a popup calendar will appear.

Microsoft Access

The user can then select the date from the calendar object and click on the "Set Date" button to return the value to the originating form.

Popup Calendar in a Subform

Here's what we mean by a popup calendar in a subform. Below is a form that contains a subform. In that subform, there is a date of birth field.

Microsoft Access

When the user clicks on the button to the right, a popup calendar will appear.

Microsoft Access

The user can then select the date from the calendar object and click on the "Set Date" button to return the value to the originating form/subform.