How to Print Table and Field Descriptions (1 Viewer)

[Echoison]

For all tables and fields you are able to type in a description, how to do print this out?

The Analyze Documenter gives you the options to print the Names, Data Types, Sizes and Properties of the Fields and the Properties, Relationships for tables but not the descriptiuons.,

Idealy, I would like to beable to print a list similar to the following:

Table 1: Descrition
Field 1: Description
Field 2: Description
Table 2: Descritpion
and so on.

Any help would be appreciated.

Thanks.

 

[Mile-O]

If you look closely, the Documenter has included the descriptions.

Between ColumnWidth and Display Control.

 

[Echoison]

Thanks, I guess it would have helped if I had put something in the description to test things out.

I see it prints the description as part of the Properties. Is there a way to select only a few (or the just the description) from the list of properties in the Documenter? I could not see an easy way unless you can do that through the Queries. Is this possible?

Thanks again for the help.

 

[Pat Hartman]

The documenter isn't too easy to customize. You can save the report to a table and create new reports on the table. This will give you better control. You can also loop through the fields collection to write your own documenter.

 

[jempie]

I cannot design the report - unless someone know's a sneaky way of doing it!

Has anyone been able to do this?