Access 2003 - Can I add a calendar to a form so it displays prop

Hi Maewyn,

Thank you for your question.

There are two possible ways of doing this. if you have added an Active X Calendar Control then you will need to copy the following VBA code into a new procedure in the VBA window.

Private Sub MyCalendar_Click()
Me.Test.Value = Me.MyCalendar.Value
End Sub

In this example the fieldname is called 'Test' and the Calendar Control is called MyCalendar.

Open the form in Design View and do ALT + F11 on the keyboard to open the VBA window. On the left hand side you will see a panel. Double click on the form you created and paste the code into the right hand window.

The date selected on the calendar control will be displayed in the text box.

Alternatively add a Text field in Design View of the form and open the properties window. Change the format of the field to Short Date. When they click into the text box a calendar control icon appears and when selected a drop down calendar appears. Whichever date is selected the date appears in the text box.

I hope this helps you and answers your question.

Regards

Simon