#error

[Bruce Rodtnick]

I have a text box (txtLengthOfService)that calculates the length of time
in years, months and days from two other text boxes called
EnlistmentDate and DischargeDate.

txtLengthOfService calls a function
(=YearsMonthsDays([EnlistmentDate],[DischargeDate])) to do its work and
it works fine unless there isn't anything in the other two text boxes,
in which case I get a #error message. I've tried and IIF(isNull)
function, but it does not solve the problem. Any ideas of what I should
do?

Bruce Rodtnick