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 Mike Lewis 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?

Access Howto:

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

by  DougP  Posted    (Edited  )
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).
SYMPTOMS
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.
CAUSE
This can happen under certain conditions if the Name AutoCorrect feature is enabled.
RESOLUTION
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.

http://support.microsoft.com/support/kb/articles/Q245/0/25.ASP?LN=EN-US&SD=gn&FR=0&qry=Q245025&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=NTW40
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