Why not just compare the date being input to DateAdd("yyyy", -18, Date())?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Ken Snell (MVP)" wrote in message
...
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...?