Originally Posted by
June7
You use a textbox and have form open with focus on that textbox. Can have code open a message box screaming "ENTER DATE NOW" if you want but that just annoys users and they can still leave the textbox after closing the message. Triggering an input box from a textbox expression accomplishes nothing except frustration, as you already experienced. Just not designed to work that way. Code would be in an event procedure or macro behind the form and pass the value from the input box to the textbox. Manage data validation by other means. One is to set the field as required, other methods involve code to verify data before record is saved.