By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,220 Members | 1,372 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,220 IT Pros & Developers. It's quick & easy.

MS Access 2007 printing

P: 1
I had developed an application using MS Access 2003 and in my reports I have no problem whether viewing or printing it in one page from my PC or Notebook. Also no problem when I opened this application in MS Access 2007 in my PC or Notebook and printing the report (either in MS Acceess 2003 or 2007). By the way my printer is HP Laser Jet 1022. My problem is when I deploy this application on another computer, and the printer is also different (HP laser jet P2014), when I view or print it using MS access 2007, the view or print which should be one page breaks into two pages. I have tried and checked the printer settings or page setup but I canít seem to be able to solve the problem. The margins in the page setup have been set to the lowest possible to maximize the page width yet it is not enough to be able to bring together the report into one page.
Can you please help Thank you.
Sep 30 '08 #1
Share this Question
Share on Google+
1 Reply


mshmyob
Expert 100+
P: 904
I have run across this with AC2007 and a quick fix is just to apply the default print driver like so before printing.

Expand|Select|Wrap|Line Numbers
  1. Dim strDefaultPrinter  As String
  2. strDefaultPrinter = Application.Printer.DeviceName
  3. Set Application.Printer = Application.Printers(strDefaultPrinter)
  4. ' put your printing code here
  5. Set Application.Printer = Nothing
  6.  
Hope this helps

cheers,
Sep 30 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.