Ms-access Field Description

[praymond]

Is there a way through VB to view the "Description" of a field in an Access table? ie in table design, you can view/edit Field Name, Field Type and Field Description. Cannot find any source that will allow ADO to view the Field Description. Anyone know?
Thanks
Paul

[phinds]

check the object browser for methods/properties

[praymond]

I checked both the ADODB and ADODX libs and there doesnt seem to be anything, yet in MS-ACCESS the description field shows in listview, so MS must have a property to cover this field. Can't even seem to find an API either.

[phinds]

if it can be done in Access, then it can be done in VB. Try doing it manually with the macro capture turned on then look at the code behind the macro.

[M Owen]

TableDefs ... Check them out.