I'm trying to calculate DOB based off the specific date 4/30/2006. I've read all the posts and have entered the following expression in the control souce of an unbound text box in my form: =DateDiff("yyyy",[DOB],$4/30/2006#)+(Format([DOB],"mmdd")>Format(#4/30/2006#,"mmdd")). [DOB] is a field in my table. It is not doing anything. When I transfer back to the data entry view of my form #Name? appears in the box that should contain/display my calculation. What am I doing wrong? I'm getting very frustrated. Any help anyone could give would be great. Is there another way to caculated the age.