Checking for "No data" in a memo field

[BrazilTechie]

Hi guys:

I am trying to run a query to filter records in which a memo field has no data.

Can someone help me here? I have tried to use IsNull and memofield = "" or " " but it's not working.
Am I missing something?

Thanks in advance.

 

[randysmid]

Hi,
Did you set the criteria line for the memo field to IsNull?
HTH,
Randy Smith
California Teachers Association

 

[scriverb]

If you want to include records with no data in the Memo Field use a criteia line like this:
Is Null

The reverse to exclude the records with no data in the Memo field:
Not Is Null

Now this is assuming that you have not set up your table with a default value of a space or empty string or something like that. You tables memo field should have a default value of Null.
Bob Scriver

 

[BrazilTechie]

Yes I did but it is not working (???)

 

[BrazilTechie]

Hi all:

I got it! I was using IsNull in the criteria instead of
Is Null plus I made the field default is Null as per ScriverB.

Thanks to all

 

[scriverb]

Does the query have other fields being selected besides the Memo field column? The code is correct. The problem lies with your data. Do some checking on the data. Find a record and put your cursor in the memofield and see if you can backspace a space out. Bob Scriver

 

[scriverb]

We crossed postings. Glad to see that you got it to work. Bob Scriver