Date Picker, Office 2007
Jul 30 2010, 09:22 AM
Joined: 27-March 07
Is there any way to enable the date picker on an unbound text box? My ActiveX controls from older versions of Access have stopped working and I'm looking for a quick solution. Any help appreciated.
Jul 30 2010, 09:45 AM
Joined: 29-March 05
nstead of an ActiveX control, you can use a user-created date picker based on a form in the way you describe. For example, check out the TimePieces Demo in our code archive forum.
Hope this helps,
Jul 30 2010, 10:02 AM
Joined: 17-June 10
From: Dorset. UK.
Since you are presumably using Access 2007 (accdb format) you can show the built-in Date Picker pop-up form when an unbound control gets the focus.
Just make sure the control's Show Date Picker property is set to For Dates and the Format property has a valid date format (say Long Date or whatever) and when the focus moves to the control the date picker form will appear.
|Search Top Lo-Fi||27th March 2015 - 10:39 AM|