How to Create a Calendar Using Microsoft Access
If you've ever made an online reservation for a hotel, you understand how important Calendar controls can be. They pop up and enable you to choose a date without having to type it into a text box. Microsoft Access had a Calendar control but Microsoft stopped supporting it in 2010. If you build Access forms that have Date fields, you can still help people add dates to form fields using another control built into Access 2013.
Open an Access database that has the relevant form and click the arrow below the "View" button. Click "Design View" to place the form in Design view.
Right-click one of the form’s TextBox controls and click "Properties" to open the Property Sheet window. Click "Data" and review the value in the "Control Source" text box. If no value is there, click the arrow next to the text box to view a list of database fields. Select the database field to which you'd like to bind the TextBox control.
Click the "Format" tab and then click the Show Date Picker drop-down menu and select "For Dates."
Click the "Data" tab and find the "Input Mask" text box. If that text box has a value, delete it because the Date Picker will not work if the TextBox control on your form has an input mask.
Click the arrow below "View" and select "Form View" to view the form in Form View. Click the TextBox control to which you attached the Date Picker control, then select the small calendar icon next to the control to display the Date Picker control (resembling a calendar). Click a date, and the Date Picker places that date into your TextBox control.
Tips & Warnings
- Repeat this process for every TextBox control for which you'd like to display a calendar.
- If your form has no TextBox controls, click the TextBox control in the ribbon's Controls section, click inside the form and use your mouse to draw a new TextBox control.
- Prevent the Date Picker from opening for other TextBox controls by returning to the Property Sheet and selecting "Never" instead of "For Dates" in the "Show Date Picker" drop-down menu.
- If you know how to program in VBA, you can code a calendar form and embed it as a subform into the form that needs a calendar. However, you'll probably find that the simple Date Picker control described here solves most of your calendar needs.