Access 2010 - validation of unbound text box
Posted on 2013-05-19
I have an unbound form, with an unbound text box, with format short date.
If the user enters an invalid date Access gives 'wrong type' error messsage. I want to do my own validation and give my own 'nicer' message.
I tried to validate in the text box lost focus event, but this is too late - Access error message came first. I then tried in the text box before update event, but again too late.
How can I catch the error myself?
(Of course, all is OK if the user uses the date picker, but not if they enter directly into the text box.)