Hello friends,
I have an unbound text box on a form named Age with the following code in the control source box:
=DateDiff("yyyy",[DOB],Date()) & "." & Int(Format(Date(),"mm")-Format([DOB],"mm"))
Unless I type a DOB in the appropriate DOB Text box, the Age text box shows the following error: #Type!
Can this be corrected? Thank you
I have an unbound text box on a form named Age with the following code in the control source box:
=DateDiff("yyyy",[DOB],Date()) & "." & Int(Format(Date(),"mm")-Format([DOB],"mm"))
Unless I type a DOB in the appropriate DOB Text box, the Age text box shows the following error: #Type!
Can this be corrected? Thank you