X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Date Picker, Office 2007    
post Jul 30 2010, 09:22 AM

Posts: 8
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.
Go to the top of the page
post Jul 30 2010, 09:45 AM

UtterAccess Editor
Posts: 18,324
Joined: 29-March 05
From: Wisconsin

Instead 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,
Go to the top of the page
Peter Hibbs
post Jul 30 2010, 10:02 AM

UtterAccess VIP
Posts: 1,495
Joined: 17-June 10
From: Dorset. UK.

Hi ic60650,
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.
Peter Hibbs.
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    24th May 2018 - 10:32 PM