input date of birth and display age

[Keith Bemis]

I have a New Patient form and we have date field on it
to input DOB , can I make a box next to it that will
display that patients age automatically we need to keep
both on the form DOB and age...thanks for any help....
Keith

 

[fredg]

I have a New Patient form and we have date field on it
to input DOB , can I make a box next to it that will
display that patients age automatically we need to keep
both on the form DOB and age...thanks for any help....
Keith

As Control Source of an unbound control:

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