Use the OnSubmit Event of the form that you are using to get the database information. In that event check the Value of the Textbox that is surposed to hold the date. You can check this by using the IsDate procedure of VBScript, ie. If not IsDate(txtDate.Value) then alert "You must enter the date in this field."
If the person doesn't enter a date in the field then you can give them a msgbox and cancel the submission of the form. Otherwise you can continue with the submission of the form.

Alternate method: If there is a LostFocus Event for the control then you can check with the IsDate function at this point.

Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them? Continue reading to learn how to make your images …