Calculating age from date of birth

[debbieb]

Hello, I hope someone can help me please. I have a form which has a text box showing a person's date of birth. I want a further box showing their age. I am not sure how to do the calculation and automatically populate the age box. I have searched for old posts, there was one a couple of years ago, but I could not get my head around it.

Any help would be appreciated.

 

[jatfill]

I believe the correct statement to pull the age would be something like

DateDiff("y",Format([bday],"yyyy"),Format(Date(),"yyyy"))