Validation Rule for Date Format

[selvakumar.arc]

How will I enforce date validation in MS Access Form?

I have data sheet form in my application and one of the column named "Effective Date" need to enforce date validation. The column type is varchar and this column should accept any date range (min range to max range).



Regards,
Selvakumar R

[orange]

Why is a date field defined as varchar?
Can you give an example of an inputted Date?
You are talking about the Validation rule on the table field right?
Why not make it a Date/Time data type with General Date format and make it a required field?

[selvakumar.arc]

Why it is defined as Varchar - After deployment to production clients wants a date column without altering/deployment of the application, basically they dont want to go for database change. So we hijacked existing column and used it. We dont have any other column with date time format so we used varchar column for storing "Effective Date".
Date format - "MM/dd/yyyy" like "03/04/2014"
Validation on table field - Yes this is table field, before inserting data into table need to validate the data. I want to implement it through Validation Rule in control property.
Why not make it a Date/Time data type - It is in production and client dont want to make any database changes. They want it to handle through front end.

Please help me to solve this issue.

[orange]

You could do a CDate (yourVarcharField) to change the text to Date.
You can then check for a valid date using

IsDate(CDate (yourVarcharField)) which will return a boolean True for Date, False if not
You can do further checks based on your requirement
eg xx or more days since Start etc.

Good luck.