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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top