Table Design - Export Field Name, Data Type & Description

[Joe Z]

I was wondering if there is a way to export the Table Design Structure:

1) Field Name
2) Data Type
3) Description

Into a Spreadsheet.

I was able to do this a long time ago, but can't seem to remember. I'm using Access 2000.

Thanks!

Joe

 

[Steve2003]

I have searched high and wide under field descritption but cannot find the answer so here we go......
Is there a way of populating a list box with the description text, it is the text you fill in next data type when you have a table in design view, decribing what the fields is for.


Many thanks