You can use a table-level validation rule for this.
Open the table in Design view, click on Properties icon on toolbar, and
enter this expression in the Validation Rule box:
DateDiff("yyyy",[mydate],Date())+(Format("Date","mmdd")Format([mydate],"mmdd"))=18
Close the Properties window and save the table.
--
Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/
"normanlives8" wrote in message
...
We are trying to limit the age when imputting the data on forms.
We have the customers DOB in format (dd/mm/yyyy)and are trying to limit
the
age to 18.
Are there any validation rules to help us achieve this...?