Re: when is null field not null?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Dirk Goldgar" <dg@xxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 2 May 2006 09:55:51 -0400

"Graham R Seach" <gseach@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:OSGS2NbbGHA.3712@xxxxxxxxxxxxxxxxxxxx

Jethro,

That should be:
Len(myfield + "") > 0

Why do you say that, Graham? If [myfield] is Null, then ([myfield] +
"") will be Null, and Len([myfield] + "") will be Null. I usually code
a test for "Null or a zero-length sting" as Len([myfield] & ""), just as
Jethro already had it.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

.

Follow-Ups:
- Re: when is null field not null?
  - From: Graham R Seach

References:
- when is null field not null?
  - From: JethroUKŠ
- Re: when is null field not null?
  - From: JethroUKŠ
- Re: when is null field not null?
  - From: Graham R Seach

Prev by Date: Form shortcut to open in data ***
Next by Date: Re: Form vs. recordset
Previous by thread: Re: when is null field not null?
Next by thread: Re: when is null field not null?
Index(es):
- Date
- Thread