Text Field Validation Rule for Date

S

shm135

Hi,

I have a RESPONSE field on my table. This field is set up as a text
field (I do not want to change it due to specific requirements)-
however, I'd like to set up a validation rule to determine whether or
not it is a valid date: mm/dd/yyyy. What should I input in the
validation rule?

Thanks
 
K

KARL DEWEY

I do not think it is possible at table level but in your data entry form us
AfterUpdate event and IsDate function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top