ADO » Fields » Count
The Count property returns a long value that is the number of items in the collection.
The counting starts at zero. You can use this value to loop throught the collection by iterating from zero to the value of Count minus one.
Examples
Code:
intCountNumber = objRecord.Fields.Count
Code:
For Each objField In objRecord.Fields
' place code here to manipulate each item in collection
Next
Explanation:
You can also use the VB/VBScript For Each ... Next statement.
