Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do I print the design view without going through the Database Documenter?

My goal is to just have a list of fields, types, and field descriptions for a table, nothing more.

share|improve this question
What's wrong with the database documenter? Too verbose? And what do you mean "print"? Do you want a report, or do you just want the results in textual form? – David W. Fenton Jul 26 '10 at 18:08
Too verbose indeed. The minimal options give me field name, type, and length. But I also need description. If I check the "properties" option, I get far too much information. The ideal would be just to be able to print the design view, actually. With "print" I meant "print." ;) Textual or report. Doesn't have to be pretty. – Domus Jul 26 '10 at 22:34
Do you know VBA? – Remou Jul 30 '10 at 19:18
Yes, I have also seen a VBA solution. I was just looking for a quick and dirty solution. This isn't something I'll be needing on a daily basis. Thanks. – Domus Aug 1 '10 at 16:15
up vote 2 down vote accepted

When you have the table open in design view

  1. Click database tools » database documenter » all object types
  2. Select your table you want to print
  3. In the 'Include For Table' area, remove all 3 checks from the boxes
  4. In the 'Include For Fields' area, choose 'Names, Data Types, Sizes'
  5. In the 'Include for Indexes' area click 'Nothing'.
  6. Ok » Ok » Close the Table? » Yes

Then print

share|improve this answer

Often wished for the same thing. Sometimes a screen capture can help, at least in seeing the information, even if it isn't cut/paste capable.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.