Printing Field Description

  • Thread starter Thread starter Nathan
  • Start date Start date
N

Nathan

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

Thx.
 
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")
 
Back
Top