Query and Null Values

[ydrasil281]

Hello

Looking to get some help with a query I am doing I am using Like "*" & [forms]![myform]![myformfield] & "*" Or Is Null in my Criteria field of the query, to try and get the form to display records that have blank fields but it will only display fields that have all the fields filled out. Is it possible to use criteria to force it to display the records with blank fields ? Any and all help is appericated.

[June7]

Encountered this before. Will need to handle the null value in the query by constructing a field with an expression and applying criteria to that field.

AliasFieldName: Nz(FieldName,"")

Omit the Or Is Null part of criteria.