MS Access - Print Area -Shrink To Fit

MS Access - Print Area -Shrink To Fit

Didn't find your answer?

Excel and Word are good, as you can fit one and a bit pages onto one page - easily.

My print preview in Access 2000 is a page and a bit.
Margins are too wide, fields are too wide, and I can't see shrink to fit, although it would easily fit on one page anyway.

OK - what can I do, please.
All I want to do is fit it (quickly) onto one page without copy/paste into excel.

Thanks.
raymond downham

Replies (5)

Please login or register to join the discussion.

avatar
By velohead
11th Jan 2005 19:38

feedback + 2 more questions
I am using a query, so I may have to get my head around reports, time permiting.

Changing the font (arial narrow is good)
and/or resizing the columns works, and just as importantly, is quick.

Questions...
1) I couldn't find any landscape/portrait options anywhere
2) How do you change an alignment to centre, as it defaults to either left or right.
This is for any particular column in the query itself.

Thanks So Far.....

Thanks (0)
Routemaster image
By tom123
11th Jan 2005 09:38

Export
Have a look on the File menu (you may need to extend the menu to it's full size) for Export.
Then export the table or query to Excel, and print with shrink to fit.

Pivot tables usually have a menu icon for export to excel.

Access does not seem to have a shrink to fit function, which is a shame, maybe soon?

Thanks (0)
avatar
By listerramjet
11th Jan 2005 09:12

format
if you have the relevant table or query open, and then click to select the whole of it, you can alter the font size (I often use arial narrow at 8 point), and you can also alter the column widths, and you can save these settings separately for each view. The print preview will keep these settings, and should resolve your problem as described.

As an alternative you could try printing landscape

Thanks (0)
avatar
By neileg
11th Jan 2005 09:23

What are you printing?
If it's a table or query, consider using a report instead. You have full control over the layout. The report wizard will knock up a report in seconds and will adjust the sizing to fit to the page width. You can tweak it yourself afterwards if needs be.

Thanks (0)
avatar
By listerramjet
12th Jan 2005 09:15

answers
Questions...
1) I couldn't find any landscape/portrait options anywhere

Try file and page set up - and then the page tab (this is in Access 2000)

2) How do you change an alignment to centre, as it defaults to either left or right.

I don't believe this is possible in Access 2000. I believe the alignment is related to the field type.

Thanks (0)