I hope this is a very simple question for a change.
I have a table with a Memo field. I wish to select all records in which the Memo field has no data. I have tried: IsEmpty/IsNull/Nz, but all of these yield no records. I have no problem selecting records that have data in the Memo field. Actually, IsNull and IsEmpty give me an empty new record.
I have spent an hour looking on the web and tried all I could with not results.
As always any help will be greatly appreciated.