- Bad IIF Construction: An MS Access legacy database
reported as crashing. All ordinary remedies failed.
- IIF Usage in Queries, and Form & Report controls were
missing the 3rd argument.
It was difficult to determine which version of VB was in use in DAO functions.
VBA is version 5.3, VB 6.0 was the last VB version prior to .Net. It would appear
that an old version of VB Script was used in DAO function assemblies.
If you try to put in an IIf without the 3rd argument in VBA, a syntax error occurs.
An example: IIf(IsNull(Field), "No Value")