Empty Text Field Problem

[Guest]

I am applying the following criteria in my listbox query: HAVING (Table.NAME)
Like("*" & [Forms]![Frm]![Textbox] & "*")

I want show all records if [Forms]![Frm]![Textbox] is empty. But when
Table.NAME is null the record will not show up.

How can I make sure the criteria is applied only when
[Forms]![Frm]![Textbox] is not empty ?

 

[Guest]

Add like this --
Like("*" & [Forms]![Frm]![Textbox] & "*") Or Is Null

 

[OfficeDev18 via AccessMonster.com]

You can use the Nz() function, as in
HAVING (Nz(Table.NAME," ") = " ") Or (Table.NAME) Like("*" & [Forms]![Frm]!
[Textbox] & "*")
That will bring "up" your null records.

I am applying the following criteria in my listbox query: HAVING (Table.NAME)
Like("*" & [Forms]![Frm]![Textbox] & "*")

I want show all records if [Forms]![Frm]![Textbox] is empty. But when
Table.NAME is null the record will not show up.

How can I make sure the criteria is applied only when
[Forms]![Frm]![Textbox] is not empty ?