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 database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. 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 Access Level 2 for $1.00 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources 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