The problem with the IIF Statement is that it validates/evaluates both True and False Arguments regardless of the Result, eg.

Debug.Print IIF(1 = 1, 5 + 5, 10 + 10)

Even though this would always Display 10, it still checks and evaluates 10 + 10.

So even though you check for Nulls in the Expression Part, it still tries to use the Null Value when Validating the False Parameter of your IIF Statement.

------------------
Aaron Young
Analyst Programmer
[email protected]
[email protected]