title: MS Access 2016 VBA Is Null in combined Query Criteria
body: <p>Given a Query with the criteria that uses text boxes in access. It works fine.</p>
  
  <pre><code>Like IIf(IsNull([forms]![f_form]![txt_box]),"*",[forms]![f_form]![txt_box])
  </code></pre>
  
  <p>The above criteria works fine when a cell has a value. However, a lot of cells in the table which I search in, is null.</p>
  
  <p>My best and logic shot was:</p>
  
  <pre><code>   Like IIf(IsNull([forms]![f_form]![txt_box]),"*",[forms]![f_form]![txt_box])
  OR Like IIf(IsNull([forms]![f_form]![txt_box]),Is Null,[forms]![f_form]![txt_box])
  </code></pre>
  
  <p>However, this does not work.</p>
  
  <p>If i just use "Or Is Null" then it returns all records where a cell is null even when i do a specific search.</p>
  
  <p>Any suggestions?</p>
  
  <p>BR, Emil.</p>
  
  <p>Edit: The solution so far was to put in "-" in all null cells, but when the users leave a cell blank (Null), the record will never show up in the filter (Query). Hence I do not prefer this solution.</p>