Get caption from field

When you design the tables of a database, you can add a descripcion, caption, comment or message to each field.

How can I get this descripcion of each field using RDO?

Any idea will be deeply appreciated.

Thanks!

Tonatiuh

It's not in the database, it appears to be a PROPERTY. Which one, I'm not sure...

ADO fields, have a property called 'Properties' and one of that returns de description of the field but, RDO column doesn't have this property or any other which seems that.

I'm not familiar with RDO, but I'm assuming it's kinda like ADO, where I could only get 3 properties for a field. I was able to get 25 fields using Jet, most of which you are looking for......

Dim db As Database
Dim rs As Recordset
Dim tbl As TableDef
Dim I As Long

Set db = DBEngine.OpenDatabase("biblio.mdb")

Set tbl = db.TableDefs("Authors")

For I = 0 To 24
MsgBox tbl.Fields("Au_ID").Properties(I).Name
Next I