N Nathan Aug 22, 2003 #1 How do I print a table field's description? Tools, Analyze, Documenter doesn't give an option to add description. Thx.
How do I print a table field's description? Tools, Analyze, Documenter doesn't give an option to add description. Thx.
A Allen Browne Aug 23, 2003 #2 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")
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")