2

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.

  • 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
2

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

0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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