MS Access: Bad IIf Construction


Menu Expand/Collapse Menu

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")

Access Cases