Recordset.Fields("FieldName")

[rgbanse]

I've used this type of code to determint the value for that field in that record.
What will tell me the Ordinal position of that field within that record. I know I've seen it before but can't bust the code.
Thx
RGB

 

[vpelleri]

Not sure how to do what you asked but as I remember, an object's ordinal position is dependent on the order it was added to the collection (beginning with 0).
So you could loop through the collection and assign numbers corresponding to the ordinal position as an array.

Vince

 

[vbajock]

I think it is rs.fields.property eg. fields(0).name gives one the field name rs.fields(1) = sometext sets the value, etc

 

[rgbanse]

Found it !!
RecordSet.Fields![FieldName].OrdinalPosition gives the position of the field in the record.
Keep in mind that the first field is (0) position
Thx for the options
RGB