How To Fix Access Date Picker Not Showing Issue

How To Fix Access Date Picker Not Showing Issue

Does your MS Access Date Picker stopped working or Date Picker Not Showing? Don’t have any ideas on how to fix Access date picker missing mystery?

Leave all your tension, as in our today’s topic we will discuss this specific issue. If you are a newbie to this MS Access Date picker control then also this post will be informative to you.

So what are you been waiting for…!

Grab every pinch of detail regarding MS Access date picker, how to insert date picker in Access and of course, best fixes to resolve Access Date Picker Not Showing issue.

Fix Microsoft Access Issues
Run a database Scan with Stellar Access Database Repair Tool to repair inconsistent Access database. After the scan is complete, the repair process will restore the database to its normal state fixing all the errors.

By clicking the button above and installing Stellar Repair for Access (14.8 MB, $79 USD), I acknowledge that I have read and agree to the End User License Agreement and Privacy Policy of this site.

What Is Date Picker Control In MS Access?

In Access, the Date picker is one such tool using which users can easily put the date in the Microsoft Office InfoPath form just by tapping a little pop-up calendar.

Here are the following circumstances under which need of Access Date Picker control seems essential. Or you can say when to use date picker in Access.

  • It helps the user to input dates on the form as per their choice. Like the starting and ending date of a particular project.
  • For showing current date and time on the form by using the Now and Today function of the date picker.
  • To show dates from the external data source like shipping and billing date from the database of customer orders.
  • Date picker in Access can also be used to collect date of birth from customers on the insurance form.

In the following figure, the date picker is used on a Tour request form template for collecting the departure date of the flight.

Access Date Picker

It’s been too easy to customize the date picker as per your needs. The only thing you need to do is just make a double tap on the date picker control present on the form template. After then make changes in its properties.

After taking a quick overview of how date picker control is useful it’s time to move on to our next section i.e how to insert date picker in Access.

How To Insert Date Picker In Access?

How To Insert Date Picker In Access

Well, this section of how to insert date picker in Access is not only for those who haven’t used the date picker control in Access. But it is also helpful for those who are encountering the Access Date Picker Not Showing issue. As they can try some other ways to insert Date Picker in Access other than the one they are already been trying.

Methods Of Inserting The Date Picker in Access

The method of inserting the date picker depends on:

  • Whether you are inserting it on the fresh blank form template.
  • Or you are inserting the date picker on the form template which is based on the existing data source.

The following figure is to show you how the date picker control in Access looks like in the design mode.

date picker control in Access

Method 1: Insert The Date Picker On Blank Form Template

When a user designs a new blank form template, the “Automatically create data source” checkbox is selected by default in the Controls task pane.

This allows InfoPath to make groups and fields in the data source automatically when you add controls on the form template.

You will see, these groups and fields appear with an icon of folder and files in the task pane of the data source.

  1. Go to your form template and put your cursor where you are willing to put the date picker control.
  2. If in case, Controls task pane won’t appear then tap on the More Controls present within Insert
  3. Now within the Insert controls, tap on the Date Picker option.
  4. For adding a label on the control. Just type text either on the left side or on the upper side of the control, after putting the colon (:) sign.
  5. For specifying the way, a date is shown on the Access form. You need to double-tap date picker which is inserted with the Access form template.
  6. Tap to the Data tab and after that hit the Format option.
  7. In the dialog box of Date Format, tap to the Display the date like this Through this way you are choosing the format in which you want to display your dates.

Note:

You can make easy modifications in the date’s display format only when the data type is in date, text, or in date & time.

Method 2: Inserting Date Picker On The Form Template Based On The Existing Data Source

If you designing your form template on the XML file, web service, database. Then InfoPath derives groups and fields present in the task pane of data source from Existing Data Source.

In that case, you can insert a date picker either in two ways:

  • Firstly by simply dragging the date picker control from the task pane of Data Source, on the Access form template.
  • Or secondly by using the Controls task pane

Let’s know how to insert date picker control by making use of Controls task pane.

  1. Go to your form template and put your cursor where you are willing to put the date picker control.
  2. If in case, Controls task pane won’t appear then tap on the More Controls present within Insert
  3. Now within the Insert controls, tap on the Date Picker option.
  4. In the dialog box of Date Picker Binding, make a selection for the fields within which you will store your data of date picker. After then tap to the OK
  5. InfoPath makes use of group and field names like a control’s label. If you want to change it then change it through the label text.
  6. Specify the style in which your data will be displayed on the form. For this just make double click on the date picker present on the access form template.
  7. Now go to the Data tab and click the Format option.
  8. From the opened dialog box of date, format tap to the Display the dates like this list box, to choose the display format of your date.

How To Fix Access Date Picker Not Showing

How To Fix Access Date Picker Not Showing

If still by trying some another way of inserting date picker in Access won’t resolve the Access Date Picker Not working issue. Then the chances are high that the Input Mask property is set to any value.

In most cases, it is found that removing the Input Mask Property from the date picker has fixed the Access Date Picker Not showing the issue.

So try it….!

If you are creating a database in MS Access latest versions like 2007/2020/2013/2016/2019 then the text control that is bounded to the data type field of “Date” will automatically start showing date picker either with or without the input mask.

Access Date Picker Not Showing 1

Even the Unbounded text field also shows the date picker if you have set the “Format” property to some valid date format. And set the “Show Date Picker” property to “For dates”.

Access Date Picker Not Showing 2

This works only when the Input Mask property is not assigned and left blank.

If you assign an input mask over the unbound text field, then this will stop the working of date picker immediately.  Check out the shown example for a clear idea.

Input Mask Property is Blank:

 

Access Date Picker Not Showing 3

Input Mask Property is set to any value:

 

Access Date Picker Not Showing 4

Result: Date Picker is available:

Access Date Picker Not Showing 5

Result: Date Picker is Not Available:

Access Date Picker Not Showing 6

This happens also when someone uses Microsoft Input Mask Wizard for setting up the input masks.

Wrap Up:

Hopefully, the above post works best to resolve your Access Date Picker Not working issue. You can try any of the above-mentioned ways to resolve Access 2016 date picker not showing.  Either you can try a new way of inserting date picker into Access database or you can remove the input mask property.

If meanwhile performing any of this method if you find any difficulty then asks freely in our comment section.

tip Still having issues? Fix them with Stellar Repair for Access:

This software ensures seamless repair & recovery of ACCDB & MDB database and restores all objects including tables, reports, queries, records, forms, and indexes along with modules, macros, etc. Fix Microsoft Access issues now in 3 easy steps:

  1. Download Stellar Access Database Repair Tool rated Great on Cnet.
  2. Click Browse and Search option to locate corrupt Access database.
  3. Click Repair button to repair & preview the database objects.

Avatar

Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access & sharing tech blogs.