When to avoid using input masks in Access
As useful as they are, input masks are not appropriate in every situation. Don’t use an input mask if following circumstances apply to you:
-
People occasionally need to enter data that doesn’t match the mask. An input mask does not allow exceptions.
-
You plan to use a Date Picker control with a Date/Time field. Input masks are not compatible with the Date Picker control.