How to remind the user to re-enter the correct date

[Mebrahtu]

When you enter date 31/06/2016 i.e. 31 June 2016 to a form an error message says;

Run-time error ‘3421’:
Data type conversion error.

Can you help me to fix using a pop up message to remind the user to re-enter the correct date?

[prw1]

A couple of things you can do.
1) Do a Google search for access error handling. There is a ton of info out there.

2) Put a format mask on the date field. Again, if you don't know how Google date formatting in access vba (or something similar.

3) When a user gets the error, display a friendlier error message (i.e. "Please enter a valid date" in a message box.)

4) Ensure that your date field is in the proper format that you want. And that the field in, in fact, a date field.

[Mebrahtu]

Thank you, prw1, for your reply.
I will take full consideration the information you provided.

Thank again.

[jforbes]

I think you can change the Format of the TextBox to Short Date and Access will make sure the user enters a valid date.