Validation rule

[Ant]

I am trying to create a validation rule in the DOB field of a table to
ensure the person is 16 years of age or older, can any one help with this?



Thanks

[Allen Browne]

Re: Validation rule

Try:[color=blue]
>= DateAdd("yyyy", -16, Date())[/color]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ant" <ant.snell@virg in.net> wrote in message
news:QUNQc.455$ H5.33@newsfe3-gui.ntli.net...[color=blue]
> I am trying to create a validation rule in the DOB field of a table to
> ensure the person is 16 years of age or older, can any one help with this?[/color]

[Ant]

Re: Validation rule

Thanks for that I thought it would be somethin simple.


"Allen Browne" <AllenBrowne@Se eSig.Invalid> wrote in message
news:4113a419$0 $16322$5a62ac22 @per-qv1-newsreader-01.iinet.net.au ...[color=blue]
> Try:[color=green]
> >= DateAdd("yyyy", -16, Date())[/color]
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Ant" <ant.snell@virg in.net> wrote in message
> news:QUNQc.455$ H5.33@newsfe3-gui.ntli.net...[color=green]
> > I am trying to create a validation rule in the DOB field of a table to
> > ensure the person is 16 years of age or older, can any one help with[/color][/color]
this?[color=blue]
>
>[/color]