>>What is a simple way to add a bit of code to form1.text1.valid so that the text entered as datetype DATE is validated so that the user gets more than "invalid data"? The situation we encounted was the following. User enters 02/30/2009 and does not realize this is an invalid date. He thinks the app is "locked up" because it won't let him leave the field. How can I give him a good MESSAGEBOX about the date being wrong or just blank the date valid he entered so at least he can select the form button that allows him to clsoe the app?
>
>I believe that the better approach is to open the calendar and give user only the choice to select correct date, not type it. You may use MS Date Time Picker ActiveX control.

For some users it's easier and quicker to type date than to use mouse to pick it.