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

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

Similar Threads

TableDef Description 2
printing table properties with description coumn in asscess 2
Long Descriptions for Fields 6
Generic Description Table 15
Table column headings 3
Print Design View 6
how do you print field properties? 6
Data Dictionary 18

Back
Top