It appears that when one uses an IIF(condition,Exp1,Exp2), both Exp1 and Exp2 are evaluated when only one should be based on the condition.

Ruud, could you please alter the current IIF code so that only one expression is evaluted after the condition is checked?
_________________________
Home page: http://www.kixhelp.com/hb/