Validate Field Containing Date AND Time

[tndinnc]

I have a field that contains an input mask : 99/99/00\ 99:00;0;_ this allows the user to enter a date and time in one field. Such as 04/24/13 15:00 . I want to put validation on that field, so that the user can't enter a time that does not exist such as "25:30" or a date that hasn't happened yet. Can someone give me some pointers on how to accomplish that? The data is going into a linked SQL table so I'm limited on what I can do on the table end I think. Thanks

[June7]

Could try the IsDate function.

But if the control is bound to a date/time field, Access should automatically handle the validation and not allow bad values, user will get error popup.

[tndinnc]

Could try the IsDate function.

But if the control is bound to a date/time field, Access should automatically handle the validation and not allow bad values, user will get error popup.

Worked great thanks - both but I went with the isdate.