Phillip said:
I have a report that I want to print on 8 1/2 inch tall by 5 1/2 inch wide
paper. How do I select a paper size to meet my needs? I know I can do it my
changing margins, but I hope there is better way of specifying a paper size.
Go into the list of Printers under the Settings button from the Start
menu. You may need to do this on the print server and you might need
admin privileges. Then click on File >> Server Properties Then you
can create a new form with the sizes you want on it as well as a name.
Then you can follow the below steps inside Access to choose the just
created Paper Size. Go into the design of the report, Click
'File',Page Setup', Click the 'Page' tab., Select 'Specific Printer',,
Pick the printer you are using., Click 'Properties' then the 'Paper'
tab., In 'Paper Size' select 'Custom'. and choose your just created
Paper Size.
Also, is it possible to print preview a report and have it display at 50%
size?
Yes, there's some kind of zoom variables. Oh, I even saved it.
'This code was originally written by Terry Wickenden.
'It is not to be altered or distributed,
'except as part of an application.
'You are free to use it in any application,
'provided the copyright notice is left unchanged.
Private Sub cmdPreview_Click()
DoCmd.OpenReport "CounterInformation", acViewPreview
DoCmd.Maximize
DoCmd.RunCommand acCmdFitToWindow
'The number at the end represents the % zoom
' DoCmd.RunCommand acCmdZoom10
' DoCmd.RunCommand acCmdZoom25
' DoCmd.RunCommand acCmdZoom50
' DoCmd.RunCommand acCmdZoom75
' DoCmd.RunCommand acCmdZoom100
' DoCmd.RunCommand acCmdZoom150
' DoCmd.RunCommand acCmdZoom200
End Sub
Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages -
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -
http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see
http://www.autofeupdater.com/
Granite Fleet Manager
http://www.granitefleet.com/