3

In Microsoft Access, 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.

4
  • 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? Jul 26, 2010 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, 2010 at 22:34
  • Do you know VBA?
    – Remou
    Jul 30, 2010 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, 2010 at 16:15

3 Answers 3

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

1

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.

1

If you have the possibility to connect your computer with a monitor with resolution sufficiently high (i.e. a HD tv, through chrome miracast function), you can move the Access window on the big monitor and get a complete view of your schema in the design view.
Then you can take a screenshot of it.

If someone could build an app that emulates an extra monitor with the possibility to set its resolution, that could be used for the same aim.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .