Private Sub Command1_Click() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim fld As ADODB.Field ... Set rs = cn.Execute("SELECT * FROM ...") For Each fld In rs.Fields Debug.Print fld.Name, (fld.Attributes And adParamNullable) <> 0 Next End Sub
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim fld As ADODB.Field
...
Set rs = cn.Execute("SELECT * FROM ...")
For Each fld In rs.Fields
Debug.Print fld.Name, (fld.Attributes And adParamNullable) <> 0
Next
End Sub