The second is by Reynald Ocampo.
Your is How to avoid Valid when a record is Canceled August 1, 1998 03:44 FAQ #7765
>Check the FAQs and Articles here, Alex. I wrote a trick for doing that...as did someone else (I forgot who).
>
>>OK, perhaps that's not the best title, but I'm looking for ideas here...
>>
>>I have a text box on a form for the user to type the date.
>>
>>The date is valid ONLY if it's < date() .and. > date() - 120
>>
>>The default value is blank. I NEED users to actually enter the date even if it's today.
>>
>>The problem I'm having is that if the user opens the form and decides not to input anything, and click on the CANCEL button, the text box's valid event fires, and until the user enters a date, he won't be able to cancel.
>>
>>If he presses the ESC key, he's able to leave the form and validation doesn't fire.
>>
>>Any way to bypass the valid event if the user clicks the Cancel button?
>>
>>Discuss amongst yourselves...
>>
>>Thanks!
If it's not broken, fix it until it is.
My Blog