title: Using access vba to check if table column has null values
body: <p>I'm trying to find if the specified column has null values or no data.if null values are present in the column then gives the message box to user saying column contain nulls. 
  My vba </p>
  
  <pre><code>Dim sqlid As String
  Dim rst As Recordset
  Dim cdb As Database
  
  Set cdb = CurrentDb
  SQLEID = "SELECT * " &amp; _
     "FROM table_1 ;"
  '
    Set rst = cdb.OpenRecordset(sqlid , dbOpenSnapshot)
     Do While Not rst.EOF
     If IsNull(rst.Fields("column1").Value) Then
     MsgBox "Has nulls"
     End If
  
     Loop   
  
      rst.Close
      Set rst = Nothing
      Set cdb = Nothing
  </code></pre>
  
  <p>But when i'm running this my access goes not responding. How do i check if the column has any nulls using vba</p>