title: MS Access query check if form field is empty
body: <p>I have a multi-field form and use it to retrieve records of a table. If there is no user input in a field I want to allow "*" and Null Values for the according column, the user input otherwise.</p>
  
  <p>I tried</p>
  
  <pre><code>Like IIf([Forms]![frm_searchForm]![Titel]="" Or IsNull([Forms]![frm_searchForm]![Titel]);Like "*" Or Is Null;[Forms]![frm_searchForm]![Titel])
  </code></pre>
  
  <p>as well as</p>
  
  <pre><code>Like IIf(IsEmpty([Forms]![frm_searchForm]![Titel]);Like "*" Or Is Null;[Forms]![frm_searchForm]![Titel])
  </code></pre>
  
  <p>But in both cases, the IIf function always triggers the else expression.
  How can I check whether the field in the form is empty? Is this even possible without VB?</p>
  
  <p>Thanks</p>