Query criteria list box however if blank looks for "" not *

[Wonderer]

List box is used to run Query however if the list box is not selected then the query uses "" ...i need it to use * or ISNOTNULL i have been trying the following but having no luck can anyone guide me in the correct way

IIf(IsNull([Forms]![Menu]![List4]),"*",[Forms]![Menu]![List4])

Thanks in advance

Rob

 

[jfgambit]

Try this...

Like Nz([forms]![Menu]![List4] & "*")

 

[Wonderer]

Many thanks that worked a treat

Regards

Rob