• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 42
  • Last Modified:

how to create a report using ledger/tabloid paper? - option missing form Access 2016

how to create a report using ledger/tabloid paper? - option missing form Access 2016
0
COACHMAN99
Asked:
COACHMAN99
2 Solutions
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can set the page size on the Report Design Tools >> Page Setup >> Page Setup dialog:

Page SEtup
If you don't have a specific size, your printer driver is at fault. Try selecting a different printer in the "Use a specific printer" setting.
0
 
COACHMAN99Author Commented:
Thanks.
Maybe my question should read 'how does one create a report using ledger/tabloid paper if there is no such printer/driver installed?
Can one create a custom report based on a theoretical printer?
0
 
PatHartmanCommented:
You can build whatever you want within the limitations of Access.  It allows a max width of 22 inches
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Gustav BrockCIOCommented:
You could use the Microsoft PDF printer and adjust that to use Letter format:

Letter option
When printing, the user can select another printer, but your report design will remain.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Can one create a custom report based on a theoretical printer?>>

 Just to be clear, the answer to this is basically no. A printer driver must be installed.   However the printer may not physically exist.    Many driver installs now though check for a printer, so sometimes it can be tough to get a driver installed if you don't physically have the printer.    But you can do it with different drivers. As gustav pointed out, using a PDF driver is a good one to try for.

Then as far as the page setup, you would need to select the "ledger" paper size.   If the driver didn't have that size, most (all as far as I know) allow you to specify a custom paper size.    But you should find a ledger size on just about every driver out there because it is a standard paper size.

But Access reports are always worked with in the context of a defined printer.   You cannot design an Access report without a printer being defined on the station.

Jim.
0
 
COACHMAN99Author Commented:
Thanks folks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now