Hi,

I'm trying to automatically print the content of a table from a Jet/SQL7 database on a form.

I've constructed the tables and assigned a caption to each field in the database.
I've built an SQL statement which fills an ADODB.Recordset with all the information I need.

Now the following step is the one I have problems with.
I need to get to the Captions I entered in to the table definition in order to write the table's (Recordset's) header.

Who do I reach the captions I defined in the database threw the Recordset I created ?

Thanks

Erez