Memo field with data shows up in IS NULL filter

[er slansky]

In trying to find records with a Memo field that is missing data, I
use an IS NULL criteria on the Memo field. A record is coming back
where the Memo field does have data.

When I do a LEN on the Memo field, it comes back with 2916 characters.

If I go into datasheet view and filter on this Memo field using IS
NULL, the record shows up there too.

Does anyone know why this is happening? I've tried searching for
anyone else having this same issue but haven't seen it before.

Thanks,

ER Slansky

 

[[MVP] S. Clark]

Try Len(MemoField) = 0 instead of Is Null.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-