Share via

Issue with Date input mask

Anonymous
2018-05-08T17:19:52+00:00

When I input data in my database I get a popup that says, "The value you entered isn't appropriate for the input mask '99/99/0000;;#" Can someone help me with this error? 

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2018-05-08T19:21:21+00:00

Open the table in design view and for that field look at the properties, specifical the input mask property.

Typically, input masks are a bad idea.  They cause more frustrations than anything else.

Was this answer helpful?

0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2018-05-08T20:54:50+00:00

    Thanks,

    I used to use the input masks. It worked great for a while.  I called up support, and they wanted me to pay over $500.00 to help with this issue. I don't even own the program and it is not my fault that it happened. I think I will just use the text field for this from now on. Thank you. 

    Much Thanks

    Eli

    Was this answer helpful?

    0 comments No comments