Glenn:
Yes, IIF will process both the TRUE and FALSE return expressions, which can lead tor problems. I tend to only use IIF() if the two return expressions are static variables and not functions.
This behavior has already been discussed extensively in the following thread: iif() stack overflow exception "problem"?
_________________________
There are two types of vessels, submarines and targets.
