Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Microsoft: Access Reports FAQ

How To

How do I make a report Print to the same Printer everytime regardless? by DougP
Posted: 2 Aug 00

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.

Back to Microsoft: Access Reports FAQ Index
Back to Microsoft: Access Reports Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close