Date and time picker control (Win XP Access 2003)

Topic

New Reply

Could you show me an example of how to use the “Date and Time Picker Control”, please.

Reply | Quote

Replies

Just put one on a form. It’ll behave like a combo box, but instead of a list, a calendar is shown when you click the dropdown arrow.
The date selected is the value of the date/time picker, you can simply refer to the name of the control in the control source of another control or in VBA code.

To set specific properties of the date/time picker, look in the Other tab of the Propertie window, or right-click it (in design view), and select DTPicker Object | Properties from the popup menu.

Warning/tip: by default, the value of the date/time picker has a time component. Don’t forget to set the time to 0:00 if you want only a date.

Reply | Quote