Limits of IIF?

[Sharae]

I want a continuous form with a calculated field. But the calculation is
complex - it calculates someone's age. There is a Function CalcAge() but I
can't see the way to refer to it in an IIF statement if the birth date isn't
null. Putting this in the control source for the age test box:

=IIf(IsNull([Birthdate]),0,CalcAge())

correctly gives me 0 if there's no birth date, but "#Error" if there is one.

Is it possible to refer to a sub or function in an IIF?

newb

 

[Allen Browne]

Yes: you can refer to a sub/function in an IIf()

But a better solution might be to redesign CalcAge() so that it does not
error when you pass in Null. Here's how:
http://allenbrowne.com/func-08.html