Prev: Form - a long time to open
Next: "mid" function error in Access 2007 runtime
From: Dave C on 2 Jul 2008 06:10
It's actually not just IIF, it's just about any native Access function used
as part of a query. Nz, Format, IIF... the list goes on.

I've taken to writing local version of each of these, which resolves the
problem. But it's a pain in the neck!

Public Function MyNz( byval poValue as variant, byval poAlternate as
variant) as variant
MyNz = Nz(poValue,poAlternate)
End Function

How's that for efficient! It solves the problem, though. I hope there's a
patch to the runtime on it's way soon.
 | 
Pages: 1
Prev: Form - a long time to open
Next: "mid" function error in Access 2007 runtime