Software

Ask something
Discussion Locked

Microsof Access - Calendar appearance in a date field

0 helpful
2 replies

by ka75

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is there an option of making a calendar (like the one in the windows date and time properties or the outlook express calendar) appear in a MS Access data base form when a user is trying to type a date ?

a different option I would be happy with is an addition of a small calendar to the form, from which the user could pick a date.

many Thanks

2 replies

by john gordon

Access 2000 and XP come with a calendar control (I'm not sure about older versions) that you can insert into a form. You can select a date on this and use or store the value in the same way you would if it had been typed into a text box.

To add a calendar control go to the Toolbox tool bar and click on the icon that is a crossed hammer and spanner with 3 dots below it. A list will appear. Scroll down the list until you see the Calendar COntrol. Click on this to select it and then add it to your form the same as any other control. Use the Help to discover properties and methods.

This discussion is closed to new replies.