Calendar for textbox (1 Viewer)

MacroGuru

New member
Local time
Today, 10:01
Joined
Oct 13, 2013
Messages
5
I have started converting our Access 2003 to Access 2010 applications. In the past we have used the Calendar to pick a date to place in a textbox. I noticed that this feature will not work in Access 2010. So I looked around and saw several references to using the calendar pick feature to a textbox...but without success.:banghead:
Could someone give me some insights on how to have a textbox with a calendar icon next to it to populate the chosen date in the textbox?
Thanks for your help!
 

CJ_London

Super Moderator
Staff member
Local time
Today, 16:01
Joined
Feb 19, 2013
Messages
16,634
For each date control, open the properties, go to the format tab and select 'For Dates' for the Show Date Picker property.

So far as I know this only works for bound controls that are bound to a date field in a table, it won't work for unbound controls or fields that look like dates but are actually text or number.

Since you are converting, it may be that you will need to compact the db or perhaps create a new blank db and copy all objects across to make this work.
 

MacroGuru

New member
Local time
Today, 10:01
Joined
Oct 13, 2013
Messages
5
CJ_London,
Thanks for your feedback. I will try it as soon as I complete my current tasks.
I will get back to you.
Jack
 

Users who are viewing this thread

Top Bottom