#1 2020-09-14 00:07:58

VictorMead
Member
From: France, Sannois
Registered: 2020-09-12
Posts: 50

Starting with Microsoft Access 2007

MSAccess Date Picker Not Available for Unbound Text Fields with Input Mask

Starting with  Microsoft  Access 2007, 2010, 2013, 2016, if you create a database of type .accdb, text controls bound to date datatype fields will automatically display a date picker with or without an input mask:  Unbound text fields will also display the date picker if you set the Format property to a valid date format and set the Show Date Picker property to “For dates”:  … but only if the Input Mask property is left blank.
As soon as you specify an input mask on the unbound text field, the date picker immediately stops working.  Here’s an example:     Input Mask Property is Blank:    Input Mask Property is set to any value:      Result: Date Picker is  available :    Result: Date Picker is Not Available:      This is true even if you happen to use Microsoft’s own Input Mask Wizard to set the input mask.
If you happen to hit this bug and would also like to have it fixed, please vote for the idea on the Access user voice site: https://access.uservoice.com/forums/319956-access-desktop-application/suggestions/31526878-fix-bug-date-picker-not- available -if-unbound-text Simply removing the input mask solves the problem – if you can convince your end users that they no longer need the input mask.
Microsoft Office, MSAccess.

Programming - Microsoft Access      Date Picker

Unbound Text Field               September 20, 2017      1 Comment                           « Windows Server 2016 RDP–You must change your password before logging on the first time    SQL Server 2016 SP2 (KB) Causes SQL Backups to Fail with error 3601 »               One comment.
Do you want to comment.
Comments RSS  and  TrackBack  URI                     anotherarmchairphilosopher    Thanks for the article, helped a lot as I was having the same issue.
Permalink, Reply    March 23, 2019 9:43 pm.
Cancel reply.
(19)    (1).
(4).
(14)     (3).
(1).
(2).
(5)    (3).
(2).
(1).
(3).
(1).
(2).
(1).
(7).
(10)    (3).
(3).
(45).
(1).
Blog at  WordPress.com .

Offline

Basketball Star Slot

Board footer

Powered by FluxBB