Custom validation error message

[snorkyller]

I have a date field, and I want to customize the error message that appears if the user enter a value that is not a date.



I know how to do it using the BeforeUpdate event, or the ValidationText and ValidationRule properties.

But the default access error message still appears just before mine ("invalid data value for this field"). Is it possible to disable it?

[eric.opperman1@gmail.com]

Hide the field. Place an unbound field with no built-in Validation (like format, etc) On After update, test the content for validity in VBA, if valid, place in the hidden field. If not valid, display your custom error message.

Just a question, why not just use the date picker or an input mask?

[snorkyller]

Hide the field. Place an unbound field with no built-in Validation (like format, etc) On After update, test the content for validity in VBA, if valid, place in the hidden field. If not valid, display your custom error message.

Just a question, why not just use the date picker or an input mask?

I'm already using the date picker, you still can change the date thereafter by an invalid one. I haven't thought about using an input mask with the date picker. Maybe it would work. If not, I will use your other nice idea.

Thank you