VBA - Null errors

Problem:

Are you getting weird errors about incorrect usage of Null? Perhaps in an If Else block that doesn't seem to be working for some reason.

Solution:

Make sure you are using just Null and the function IsNull correctly. The value Null is to be used in SQL queries whereas the function IsNull() is used in VBA syntax.

For more information see the article Learn the differences between Is Null and IsNull() in Access at techrepublic.com.