How print the design view?

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.

microsoft-access

Domus

Posted 2010-07-26T16:16:56.483

Reputation: 127

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 – 2010-07-26T18:08:00.680

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 – 2010-07-26T22:34:21.090

Do you know VBA? – Remou – 2010-07-30T19:18:52.450

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 – 2010-08-01T16:15:56.573

Answers

When you have the table open in design view

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

Then print

RMU ACC2017

Posted 2010-07-26T16:16:56.483

Reputation: 36

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.

datatoo

Posted 2010-07-26T16:16:56.483

Reputation: 3 162