I get asked this all the time: "what's the difference between a NULL value and a Zero Length String."

Here's the answer:

/tips/access/null-zls

Subscribe to Access Tip: NULL vs. Zero Length Strings
Get notifications when this page is updated