Allow Zero Length. The Difference Between Null and Zero Length String. Indicate No Middle Name.

Allow Zero Length. The Difference Between Null and Zero Length String. Indicate No Middle Name.
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?
Silver Members and up get access to an Extended Cut of this video. 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.
MEMBERS VIDEO:
• Zero Length String v N...
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
599cd.com/ZLS
PRE-REQUISITES:
What is Null: 599cd.com/Null
RECOMMENDED COURSES:
Access Beginner 4: 599cd.com/ACB4
LINKS:
Null Math: 599cd.com/NullMath
NZ Function: 599cd.com/NZ
Invalid Use of Null: 599cd.com/InvalidUseOfNull
Null on No Longer Set: tinyurl.com/27o38dpm
Conditional Formatting: 599cd.com/Conditional
Conditional Formatting Null: 599cd.com/CondFormatNull
Aggregate Query: 599cd.com/Aggregate
IsNull on Microsoft: tinyurl.com/22fg8rs6
Allow Zero Length on MS: tinyurl.com/26zycs4y
Format Text Fields MS: tinyurl.com/243q867g
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
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
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@clickmelearned]

Thank You Dear

[@Stache987]

When I was in the military we used (NMN) to signify a person who had no middle name, I disliked the date format used, we still had some unit record equipment, and if date was presented as (YY)YYMMDD it could be sorted faster.

[@599CD]

I love the YYYY-MM-DD format. See 599cd.com/ISO

[@Stache987]

I can see a programiticly way to set a yes no field to trip where a field was set and no longer a null, it would allow for fast filtering.

[@599CD]

599cd.com/ask