View Full Version : Validation rule for text field for correct date


Talitha
11-15-2008, 04:15 AM
Hi gang,

I have an Access db with a text field with a date and time input mask. I am trying to work out a validation rule which will allow only an authentic date and time only. I need to leave it as a text field as that was what has been requested. <grr> Is there a way to write a validation rule which will accept only a real name (dd/mm/yy hh/mm) to be entered?

Talitha

wazz
11-15-2008, 10:19 AM
check out the IsDate function.