How do I print out the layout of a table in Access?

J

jjp001

I am using Access 2002 SP3. I am looking at the layout of a table I am
designing, and would like to print out the layout of the table containing at
least some of the information normally displayed in design view; e.g., Field
Name, Data Type, and Field Size at the very least. Pressing Ctrl-P does not
lead to a print menu, and the "Print Preview" option is grayed out when
"File" from the menu bar is clicked on. Further, clicking on Send To -> Mail
Recipient results in attempting to email the entire contents of the table,
which I do not want.

This shouldn't be such an oddball request, since a lot of character-based
DBMSes let you do this.

Thank you in advance for your reply to this inquiry.
 
T

TC

As Jeff said, or, just whip-up some code for it:

(untested)

dim db as database, td as tabledef, fld as field
set db = currentdb()
set td = db.tabledefs![MyTable]
for each fld in td.fields
debug.print fld.name, fld.type ' etc.
next
set td = nothing
set db = nothing

Enhance/add sauce as necessary!

HTH,
TC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top