Problem with Is Null function

[rbrule]

I have to create a query in which, I know several fields are blank. In the criteria of the particular field I typed "Is Null".

The data sheet showed no records, when I ran the query. When I run the query without the criteria I get all the records. If I put criteria in another field it filters properly.

What could be a reason why "Is Null" does not work in a particular field?

 

[The_Doc_Man]

You don't put IsNull in the criterion row. You make it an expression in the query's field row. The criterion row for that column will be =TRUE

Expr1: IsNull([MyTable.MyField])

Criteria: TRUE

(or something like that)

 

[Rich]

There are no quotes around Is Null, what's the data type of the field that doesn't work?

 

[rbrule]

Hi Rich
I didn't use quotes around the Is Null. The data type is text. I have used Is Null as criteria many times with no problem, in other queries. I don't understand what could be wrong.

 

[rbrule]

Thank you Pat, it was a zero length string and responded to ""