Printing Field Description

N

Nathan

How do I print a table field's description? Tools,
Analyze, Documenter doesn't give an option to add
description.

Thx.
 
A

Allen Browne

You can loop through the Fields of the TableDef to get the Description
property.
The essential reference is:
dbEngine(0)(0).TableDefs("MyTable").Fields("MyField").Properties("Descriptio
n")

Details and example in this article:
http://allenbrowne.com/func-06.html

If you prefer ADOX:
cat.Tables("MyTable").Columns("MyField").Properties("Description")
 
Top