I am using VB with a access97 back-end. I have created my database and all the tables I require. Within Vb I have created a recordset and selected the table I want, I have written a for..loop to go through each field in the recordset. But I do not want the field name, I want to access the fields caption property and get the string value of the caption.

The reason for this is because the tables I have created in the database contain digitised data for specific charts. So the field names relate to the section of the graph that was digitised, so the name of the field is related to a particular section of the chart. This is fine when you name the fields whole numbers like 1000,2000,3000..etc. But the problem arises when the name of the field should be 1.00,1.02,.1.04..etc. This creates a invalid field name, so I set the caption of the field to 1.00,1.02,1.04..etc.
But when I create a recordset in VB using ADO, I cannot access the caption property. Can anyone please help????????