counting fields in DAO

[Joacim Andersson]

Sure! A recordset contains a field collection method.

Dim iNumOfFields As Integer

iNumOfFields = rs.Fields.Count

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