title: How to check all fields of the recordset from ADO query?
body: <p>I would like to see if there is a command to show the whole record(row) at once. By now I only find method to show individual columns. I am using a ADO connection to the ms access's mdb. Thanks. By the way, I don't know how can I print a message in MS Access's VB form.......does vb provide a console to show that? Debug.Print don't give me anything, I only success with MsgBox...</p>
  
  <pre><code>   With cmdCommand
      .ActiveConnection = conConnection
      .CommandText = "SELECT * from tableA"
      .CommandType = adCmdText
     End With
  
     With rstRecordSet
      .CursorType = adOpenStatic
      .CursorLocation = adUseClient
      .LockType = adLockReadOnly
      .Open cmdCommand
     End With
  
     If rstRecordSet.EOF = False Then
          rstRecordSet.MoveFirst
          Do
  
              MsgBox rstRecordSet.Fields(0) &amp; " " &amp; rstRecordSet.Fields(1)
  
              rstRecordSet.MoveNext
          Loop Until rstRecordSet.EOF = True
     End If
  </code></pre>