Share via

Date Picker for a Combo Box of dates

Anonymous
2016-02-18T19:32:42+00:00

How can I display a Date Picker dialog for a combo box (on a form) that contains a list of dates?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-02-18T22:51:35+00:00

    I have an unbound combo box whose rowsource is a list of dates. The Limit To List is set to "NO" so new dates can be added. It would be very helpful if the user could select the date from a Date Picker instead of having to type 02/10/16.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. DBG 11,711 Reputation points Volunteer Moderator
    2016-02-18T23:09:19+00:00

    I see. In that case, you could try using this approach but you'll probably have to set the Limit to List = Yes to activate it.

    Hope that helps...

    Was this answer helpful?

    0 comments
  3. ScottGem 68,810 Reputation points Volunteer Moderator
    2016-02-18T20:44:57+00:00

    The built in Date Picker control only works with a text box set to a date format. I don't see why you would want to use it on a combobox that displays a list of dates.

    Was this answer helpful?

    0 comments
  4. DBG 11,711 Reputation points Volunteer Moderator
    2016-02-18T20:08:59+00:00

    Hmm, not sure I follow. A "date picker" usually resembles a calendar. So, if your combobox has entries for different dates, how would you like to display them in a calendar format? Can you show us an example of what you're thinking? Thanks.

    Was this answer helpful?

    0 comments