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:
UA-cam: / @599cd
or My Site: 599cd.com/THMe...
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/Null...
NZ Function: 599cd.com/NZ
Invalid Use of Null: 599cd.com/Inva...
Null on No Longer Set: tinyurl.com/27...
Conditional Formatting: 599cd.com/Cond...
Conditional Formatting Null: 599cd.com/Cond...
Aggregate Query: 599cd.com/Aggr...
IsNull on Microsoft: tinyurl.com/22...
Allow Zero Length on MS: tinyurl.com/26...
Format Text Fields MS: tinyurl.com/24...
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
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/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
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.

[@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