Sorry for the confusion. I am trying to have users enter in a search value in a form to search for an item in the database. I do not want it to be an exact value but use wildcards to make it so that if their search value is any part of the text field it will return that record..

I would like to use a form with 5 text boxes that the user can enter search values in one or up to all five text boxes and then conduct a search. If they...

I am trying to use the IIF statement to look for a null value. That seems to be working fine..

The problem occurs when I use a LIKE Statement inside the IIF statement.
Here are some examples:
but the above statement used inside an IIF statements returns nothing as in the statement below.
...