title: Check a recordset for an empty field
body: <p>I'm trying to <code>pre-view</code> if a field of the <code>recordset</code> is empty/null or not.  </p>
  
  <pre><code>If IsNull(rs.Fields("fieldname")) = True Then ...
  
  If IsNull(rs.Fields("fieldname")).Value = True Then ...  
  
  if IsNull(rs.Fields("fieldName").Value) Then...
  </code></pre>
  
  <p>All of these methods fires up an  error... Why? How may I check if the <code>recordset</code> is null before I assign it's value to a variable.</p>