counting fields in DAO

Is there a way to count the number of fields in a recordset?
I am using VB6 with DAO.
Thanks.
Dan.

Sure! A recordset contains a field collection method.

Code:

---

Dim iNumOfFields As Integer

iNumOfFields = rs.Fields.Count

---

This assumes you have named your recordset rs.
Good luck!