Automatic Age Calculation in Access using DateDiff

[whitelexi]

Since the AGE can be calculated, calculate it in a query and bind a control to the query column. There you go - AGE is never wrong!!

Please can you explain this bit in more detail...

[June7]

A form or report RecordSource can be table or query or a query that joins tables/queries. A field constructed by expression in query can be the ControlSource of a textbox. As long as field is in the RecordSource it is available to the ControlSource property. Set ControlSource to a constructed field same way as to any field.

[whitelexi]

Wow! The most weird thing just happened... with the query created and working, i copied the code:

DateDiff("yyyy",[DateOfBirth],Date())-IIf(Format([DateOfBirth],"mmdd")>Format(Date(),"mmdd"),1,0)

into the control source of the Age Field in the form and voila... It does exactly what i wanted.

Now the Age field on my form updates as soon as a date of birth is entered into the DateOfBirth field!