Is there a way to write the properties of a table out to a text file or excel sheet?

I'd like to be able to get the Field Name, Data Type, Field Size, and format for each field in my table.

Thanks,
CRhodus

How about this?

http://www.access-programmers.co.uk/forums/showthread.php?t=141161

Thanks GolfProRM! That's exactly what I need.

CRhodus

Hi

As an alternative to the previous thread here is an example (FrmDocumenter) that can be added to any mdb.

CodeMaster::cool:http://www.icraftlimited.co.uk