copy design mode of table

[smiley0q0]

is there any way i can copy and paste the design mode of a table? I need to see the Field name, the data type and the description?

thanks,
Smiley

 

[PHV]

copy and paste the design mode of a table?
paste where ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SkipVought]

Hi,

You could Copy 'n' Paste, name th copy and then open and delete the data.



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[smiley0q0]

i'd like to paste it in excel. i don't want the data, i just want to see the data design in table format... make sense?

 

[willir]

The documentation tool in Access may come close. Can be pretty verbose, but if you select only the tables, you may get what you want. You will have to cut / paste and tweak.

I like to print the schema with the relationship open.