VBA's implicit boolean conversions can trip up even experienced programmers. Negating the results of the Len() function is a perfect example.

A combination of the GetInfoForm() function, custom VBA types, and "Extract Method" refactoring helps reduce our Access application's complexity.

Did you know you can combine lines of code in VBA with the colon character? The key is to understand when--and when not--to use it.

By using the Me keyword, you can leverage the automatically generated properties to retrieve and set data in VBA.

A deep dive into the Empty keyword in VBA: why it exists, how to check for it, when it makes sense to check for it, and--most importantly--how NOT to check for it.

Wondering what the IsMissing() function is all about in VBA? We'll explore that plus all the ins and outs of the VBA keyword that isn't: Missing.

Let's explore the many ways to check for, handle, and store Null values. Spoiler alert: the best way to do it varies between VBA and SQL.

An in-depth look at the Nothing keyword in VBA: when you need it; when you don't; and one technique to avoid it altogether.

This one's for the nihilists. We explore the many ways to express the concept of nothingness in VBA.

Yes, there is a right way and a wrong way to check for empty strings in VBA. Actually, there are *two* right ways and *two* wrong ways. Let's explore all four.