After you run the documenter, you can create a link to the table that
contains all the property values. The table connection on my PC is
DATABASE=C:\Documents and Settings\Duane Hookom\Application
Data\Microsoft\Access\ACWZUSRT.MDT;TABLE=doc_tblOb jects
You can then create a crosstab with SQL like:

TRANSFORM First(doc_tblObjects_2.Extra1) AS FirstOfExtra1
SELECT doc_tblObjects.Name AS TableName, doc_tblObjects_1.Name AS FieldName,
doc_tblObjects_1.Extra2 AS FieldType, doc_tblObjects_1.Extra3 AS FieldSize
FROM doc_tblObjects AS doc_tblObjects_2 INNER JOIN (doc_tblObjects AS
doc_tblObjects_1 INNER JOIN doc_tblObjects ON doc_tblObjects_1.ParentID =
doc_tblObjects.ID) ON doc_tblObjects_2.ParentID = doc_tblObjects_1.ID
WHERE (((doc_tblObjects_1.TypeID)=11))
GROUP BY doc_tblObjects.Name, doc_tblObjects_1.Name,
doc_tblObjects_1.Extra2, doc_tblObjects_1.Extra3
PIVOT doc_tblObjects_2.Name In ("Caption:","Description:");

--
Duane Hookom
MS Access MVP


"W Garrard" wrote in message
...
Hi All,
I have to document an inherited set of MSAccess 2000 files and it would be
very helpful if I could customize the output from the tables documentor.
I
would like to have the table report output include the "field description"
(info visible in table design view) and the "caption" in addition to the
default info (e.g., field name, data type, and data size).

I assume the only way to do this is using VBA. I am pretty good at
modifying existing VBA code if someone can point me to a relevant example
for this. Of course, I would love a nonVBA option for doing this. Can
anyone point me to a solution?

Also, it would be worth upgrading to a newer version of MSAccess if the
documentor output was customizable. Anyone know this?

Thanks in advance,
wg