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 Other topics FAQ

Access Howto:

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

This works in Access '97 for Access 2000 see Notes below

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
Access 2000:
There is a bug in Access 200 which makes the default setting show up if you cancel a report before printing it.
This article applies only to a Microsoft Access database (.mdb).
A Microsoft Access report suddenly is not formatted as expected. Upon checking the printer settings, you find that they have been reset to their default settings.
This can happen under certain conditions if the Name AutoCorrect feature is enabled.
To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).
To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:
Q245025 OFF2000
Here is the link.


Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics 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