Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting Paper size for report via code 1

Status
Not open for further replies.

EddyLLC

Technical User
Mar 15, 2005
304
US
I have searched for questions relating to my issue but found no answer. I am printing a report out of Access2003 onto a pre-printed form that is not the standard 81/2 by 11. It is
8 7/8 by 81/2. The printer is a dot matrix tractor feed. The first report prints on the first one but the printer feeds the paper for the next form assuming it is a 8 1/2 by 11 so it starts printing the second report half way down the page. I tried code that sets it to landscape but the form does not feed landscape so the printing is perpendicular to the form. I also tried adjusting the margins but that does not affect the form feed. Is there a way to adjust the actual paper size via code? I looked at the page setup feature for the printer but no forms this size are listed and no custom option was available that I could find.

Any help is greatly appreciated. I'm at wits end.
Thanks
 
There are dot matrix printers still in use? Amazing! Apparently you cannot do this thru code. Had a major back problem in January and spent way too much time on line and remembered this posting:


The germaine part was as follows:

Posted by HandsOnAccess

Go To Control Panel, Open "Printer and Faxes"
Choose the printer and In the Printer Settings - Printing Preferences Change the Paper Size from A4 to "Custom Paper" / "User Defined Size." Another Small Window Pops Up asking Paper Width and Height. Type the desired values.

In Access Report Design View,
Go To "File"->"Page Setup"->"Page" Tab
Select "Custom Paper" or "User Defined Size"
Save and Close the Report

Double-checked with Simpson & Robinson's Mastering Access 2000 and they give the same advice.

The Missinglinq

There's ALWAYS more than one way to skin a cat!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top