Calculate age in a form field

[bellemmar]

Hi,
I'm trying to have a field automatically calculate age (in years) from the birthdate field. I've figured out how to do the query; I'm hung up on having it work in a form. Can I just paste the query code into the form's age field?
Thanks for any assistance.
MK

 

[Mr. B]

Take a look at this link:
http://access.mvps.org/access/datetime/date0001.htm

It should help.

 

[michaeljryan78]

You can place this in the ControlSource of the Age text box (unbound)
txtBOD = Bate of birth (can be bound
txtAge Unbound

=DateDiff("y",Year([txtBOD]),Year(Date()))