input date of birth and display age

  • Thread starter Thread starter Keith Bemis
  • Start date Start date
K

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
 
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
Click to expand...

As Control Source of an unbound control:

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