Ask a new question

Date Picker control on an unbound form in Access 2010

We just upgraded to Office 2010.  We use Access as a front end for a SQL server db.  We have an unbound Access 2003 form that collects information used to send parameters to queries and open the correct report.  Two of the fields are date fields used as  "between" parameters for a query. 

MSCAL.OCX isn't supported in 2010 and I haven't been able to figure out how to add a date picker control to an unbound control in 2010.  Suggestions?

Answer
Answer
You just add a textbox, set its Format property to one of the Date formats, and set its [Show Date Picker] property to "For Dates". Now, when you set the focus to thaqt textbox, a little calendar icon will display to its right. Click that little icon and a proper calendar control will display.
 
"BBN_BC" wrote in message news:*** Email address is removed for privacy *** .com...

We just upgraded to Office 2010.  We use Access as a front end for a SQL server db.  We have an unbound Access 2003 form that collects information used to send parameters to queries and open the correct report.  Two of the fields are date fields used as  "between" parameters for a query. 

MSCAL.OCX isn't supported in 2010 and I haven't been able to figure out how to add a date picker control to an unbound control in 2010.  Suggestions?

Regards, Graham R Seach Microsoft Access MVP Sydney, Australia

49 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated July 12, 2023 Views 61,911 Applies to: