Validation Rules for Dates

[lucour]

I have a form with a Date field. I have formatted this field so that after the user enters mm/dd/yy (I have an Input mask setup for this) it converts this to a Long date. Twice in the last while I have had a user enter just '0' into the field and then press <Enter>. This results in a date of December 30, 1899 and the record becomes corrupt and undeleteable. I have to copy the table out and then paste all the 'good' records into the new table to get around this. Is there some sort of validation rule I can setup in the event this happens again so that it will not accept the '0'?

Thanks!

 

[Rich]

Is the input mask in the field on the form?

 

[lucour]

Yes, the Input mask is defined in the txtDate field on the Form.