Get caption from field

[Tonatiuh]

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

[JHausmann]

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

[Tonatiuh]

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.

[Clunietp]

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