How to search for a 'blank' field on a form? Or a 'null' field ?

[Mel]

I click in a field on a form
I click Edit | Search
I enter... is not null

Nope. Doesn't find the next record for which that field is empth

I try... <>""

Nope. That doesn't work either.

How can I search for a blank or null field on a form in Access ?

thanks for any help.

Mel

 

[Mel]

Woops!

Should have said... How to search for a NON-BLANK field.

I'm looking at a Form... I want to click in a field and search for the
next record for which that field is NOT BLANK.

thanks again for help on how to do this search.

Mel

 

[Rick Brandt]

Woops!

Should have said... How to search for a NON-BLANK field.

I'm looking at a Form... I want to click in a field and search for the
next record for which that field is NOT BLANK.

thanks again for help on how to do this search.

Mel

If the field does not allow zero-length strings (defined in table design)
then all you should need is a filter on that field of...

Is Not Null

If the field DOES allow zero-length strings then you would need...

Is Not Null And <> ""