title: MS Access VBA Update Field with Null or Empty String
body: <p>I am trying to update a MS Access table via VBA from a DAO Recordset.  The problem is that if one of the field values is null.  The code errors out.  Is there something like <code>IsNull(rst.Fields("FirstName").value,"")</code> that I can use?  I tried using this but it throws the error "Invalid Use of Null".  Please help.</p>
  
  <pre><code>strSQL = Update myTable SET myField ='" &amp; rs.Fields("recField").Value &amp; "' where id = 25
  db.Execute strSQL
  </code></pre>
  
  <p>in this instance, <code>rs.Fields("recField").Value</code> is Null</p>