Wildcard not returning blank fields

[Solola]

I swear I've never had this problem before, but now I am (maybe I was just never previously aware that I wasn't getting the data I thought I was getting):

I have a query that prompts the user to enter text to be used as criteria: Like "*" & [Enter Supplier Name] & "*"

I used to think that if I did not enter anything in the prompt, it would return all records. However, it is not returning any rows for which the Supplier field is blank. Why not?

To get it to return 1) what is entered at the prompt, or 2) all fields if nothing is entered, how should I change my criteria?

Thanks!!

 

[petertenthije]

Like "*" & [Enter Supplier Name] & "*" OR [Enter Supplier Name] is null