Thanks!

Thanks again. I'm out of the office until Wednesday and will implement your solution then. Can always test MyTextBox.Text with IsDate in coordination with length. Can probably set validation clause for IsDate to be true thus preventing loss of focus before a valid date is present. In an extreme case, someone could type "I'm a dummy" followed by a <tab> or <enter>, which would fire the "After Update"...

Trying to validate data in a text box control on an Access 2007 form using the "on change" event and/or "after update" event. The text box (e.g. MyTxtBox) contains a date that
1) must be within a range based on the NOW() function date, and
2) must be <= another date (may be NULL) in a text box on the same form
Data for the text box can come from a date picker or keyboard entry.

The "on...