Hi,

Ok, I did as Sascha suggested and it works it prints out the name property of the columns.

It gave the same result as <Recordset>.Fields("<FieldName>").Name

But,

Since I don't want my user to receive as the headers of his table names like "fldID", "fldCustNum" etc I defined a Caption for each column in the database (AI "ID", "Customer Num" etc') What I need is to reach the captions of the table ("ID", "Customer Number" etc').


Is one of the properties contains the Caption of the fields ?

Can I reach these captions ?

Thanks

Erez