The Difference Between Null & Zero Length String

In this Microsoft Access video, we're going to learn about Zero Length Strings, the Allow Zero Length property, how a ZLS is different from a Null value, how to set all of this up in our database, and most importantly how to use them each properly.

Simon from Cleveland, Ohio (a Platinum Member) asks: I'm confused. What's the difference between a Null value and a Zero Length String?

Members

Members will learn how to use the format property to display "NULL" or (None) and in color. We'll learn about a problem with DLookup and how it doesn't work properly with zero length strings. I'll share my DLookupZLS function which does work with ZLS. We'll see how short & long text fields handle ZLS differently. We'll learn about different combinations of the Allow Zero Length and Required properties. And we'll learn about two more possible values: Empty and Nothing. This Extended Cut is jam packed with goodies, folks.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Database Download - Gold Members
• Code Vault DLookupZLS Function - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Pre-Requisites

• What is Null: https://599cd.com/Null

Links

• Null Math: https://599cd.com/NullMath
• NZ Function: https://599cd.com/NZ
• Invalid Use of Null: https://599cd.com/InvalidUseOfNull
• Null on No Longer Set: https://tinyurl.com/27o38dpm
• Conditional Formatting: https://599cd.com/Conditional
• Conditional Formatting Null: https://599cd.com/CondFormatNull
• Aggregate Query: https://599cd.com/Aggregate
• IsNull on Microsoft: https://tinyurl.com/22fg8rs6
• Allow Zero Length on MS: https://tinyurl.com/26zycs4y
• Format Text Fields MS: https://tinyurl.com/243q867g

Recommended Course

• Access Beginner 4: https://599cd.com/ACB4

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, difference between null and empty string, allow zero length, DLookupZLS, DLookup with Zero Length String, ZLS, null string, format, how to tell the difference between null and zero length string, does null = null, what does null equal, empty, nothing, required, variant