title: Handling NULL = NULL comparisons in Access VBA
body: <p>I have a problem with <code>NULL = NULL</code> returning <code>NULL</code>. I want it to return <code>True</code>. After a bit of research I found a line that I thought would work..</p>
  
  <p><code>set ansi_nulls off</code></p>
  
  <p>I quickly learned that Access doesn't recognize it. So here I am attempting to do nested conditions in Access and it's a complete nightmare.</p>
  
  <p>Is there an easier way to handle this?</p>