MS Access 2007 printing

[pusparaj]

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.

[mshmyob]

I have run across this with AC2007 and a quick fix is just to apply the default print driver like so before printing.

[code=vb]
Dim strDefaultPrint er As String
strDefaultPrint er = Application.Pri nter.DeviceName
Set Application.Pri nter = Application.Pri nters(strDefaul tPrinter)
' put your printing code here
Set Application.Pri nter = Nothing
[/code]

Hope this helps

cheers,