Format Date (Input Masks...)

[Pelton98]

I would for a user to be able to enter any type of date format and have the
date format to MM/DD/YYYY. However input masks drive me insane because it
only allows for one preference...

I would like all of the following to format to MM/DD/YYYY:

mmddyy
mmddyyyy
mm/dd/yyyy
mm/dd/yy

Can anyone help with this issue...Too many users and too many different ways

 

[Rick Brandt]

I would for a user to be able to enter any type of date format and have the
date format to MM/DD/YYYY. However input masks drive me insane because it only
allows for one preference...

I would like all of the following to format to MM/DD/YYYY:

mmddyy
mmddyyyy
mm/dd/yyyy
mm/dd/yy

Can anyone help with this issue...Too many users and too many different ways

No, unless you let them type in an unbound TextBox and then use VBA code to take
what they've typed and create a valid date value from it and then store that in
another control.

I just set the format to what I want and let them type any valid date format,
but that means they have to include a separator. The only way to allow for
entering just the digits is if you use a mask (ugh).

If people complain I use the following...

What's the complaint?
I don't like having to enter the slashes.

Why?
It's just too many keystrokes.

I see... There is also this field here that is 22 characters long. Should I
eliminate that too?
No, that's the (whatever) field and it's a critical piece of data.

Well so is the date. Get over it.