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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I make a report Print to the same Printer everytime regardless?

How To

How do I make a report Print to the same Printer everytime regardless?

by  DougP  Posted    (Edited  )
Note this works in Access '97. See notes below of Access 2000
1. Open your report in Design view
2. Click the "File" menu then click "Page Setup"
3. Click the "Page" TAB
4. Check "Use Specific Printer" at the bottom.
5. Click the "Printer..." button
6. Choose your Printer from the list
7. Click OK
8. Adjust Landscape or Portrait settings.
9. Click the Margins TAB and adjust if needed.
10. Click OK
11. Click "File" menu then Click "Save" <<<<< very important

Next time you print it should work fine
---------------------------------------------

Notes: for Access 2000 Default bug and Canceling.

I have found if you do the above steps in Access 2000 it works OK for a while.
But if you cancel a report after you have previewed it and do not print it, in Access 2000 it will default back to the settings for your Default Printer, such as Portrait and regular margins and so on. I have set up Envelopes and made many changes to margins and spent a huge amount of time getting it right. I clicked print and forget something in the address so clicked cancel. Next time I printed the Envelope it had reverted back. So I had to go back and re-do the whole Envelope all over again. Even in an .MDE is screws up.

Bottom line, donÆt cancel, just print your document and throw it away.
--------------------
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top