Query/Report of fields in table with Properties

[kwvh]

Is there a hidden table that would show the properties of fields in specific tables? For example if I wanted to create a report or query of the fields in tblMyTable and have as columns in the report/query:
Field Name
Field Type
Required
Allow Zero Length
for each field in the table, is that achievable?

Any ideas are greatly appreciated!

Ken

[HansV]

There is no hidden table containing that information (at leat, not visible to the user or programmer).

The Documenter (in Database Tools) lets you create a report that lists properties of database objects, but it is not customizable.
As an alternative, consider the Liquorman Utilities (shareware, free to try).

Here is a screenshot from the output from an old version of Mark Liquorman's documentor:

x155.png

If you want to roll your own, you can use DAO to inspect the properties of tables and fields.