how can I use date picker and input mask together?

martinr

Registered User.
Local time
Today, 17:59
Joined
Nov 16, 2011
Messages
74
I have a form (Access 2007) that requires user to enter a date.
Using the standard date field (short date format) with the date picker works fine however some users prefer to enter the date via the keyboard (some prefer the date picker).
If I set an input mask (to facilitate keyboard entry) for the text box then the
date picker disappears.
Is there any way to apply the date picker and the input mask to the control to accommodate all users?
 
Not sure if you can use input mask and a format. But with a text field, you could put a Format of Short Date and that will show a Date Picker if DatePicker for Dates Only is used.

I was thinking of an unbound textbox with a ShortDate format.
You could use some event vba to ensure no error; a Date exists; you could check Date within some range if that applies; then update your table using the textbox value.

Just thinking (untested)
 

Users who are viewing this thread

Back
Top Bottom