Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Courses > Access > Beginner > B4 > < B3 | B5 >
Back to Access Beginner 4    Comments List
Upload Images   Link   Email  
Zero Length
David Harrington 
      
2 years ago
Please tell me there is a reason for zero length text and it's not just that the programmer had a bad day years ago.. and we are still paying for it.
David Burns 
     
2 years ago
Maybe it is to show that the field has been edited at some point? &#129335;&#127995;&#8205;&#9794;&#65039;
Alex Hedley 
            
2 years ago
David Harrington OP 
      
2 years ago
Thanks Guys.  HI Alex:  I found the NULL vs Zero Length String link after posting.  Richard's statement (below), while accurate and valid, is extremely subtle.  
I am left feeling this is an artifact of how the programming language initializes variables.

excerpt From NULL vs Zero Length String:
Let's say you're tracking first, middle, and last names, and you NEED to know whether or not someone has a middle name. You could set their middle name equal to a ZLS to indicate that they have NO middle name, as opposed to not knowing what their middle name is. (NULL implied here..dmh)
Kevin Yip 
     
2 years ago
A zero-length string is considered a string, and null is not.  You can't use null when a string is needed.  They may look the same or mean the same for all practical purposes.  But in coding, you need to use the correct data type, one that is required by the code.  For instance, the function Left(s, n) won't work if s is null and not a string.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Beginner 4.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2025 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 1/14/2025 8:15:44 AM. PLT: 1s