Access - Printing Report

[Mary]

I'm using Access '97 Prof., HP OfficeJet Printer.

I have a report set up for 8.5 x 11 page. I want to
automatically print one page with all information & the
next page with a different layout.

I have tried increasing the size of the page in "Design"
to twice the size. However, when you go to view or print
the page, it shows up as two pages.

Is there any way to add a custom size paper. If I could
define & select the page as 8.5 x 20 in the printer
settings, then Access should see both pages as one page.

I realize that I could print pages 1 to 2 for record 1,
but I don't want the user to have to figure out & key in
both page numbers.

- Does anyone have any ideas?

[Dana Mansolillo]

Mary,

Setting print options in Access is the worst!!!

Attached is code I am using. Let me know if you need help.

I found this article...

In previous versions of Microsoft® Access, the only way to
programmatically retrieve and work with the printer
settings of forms and reports is to use the PrtDevMode,
PrtDevNames, and PrtMip properties, which are available
only when a form or report is open in Design View. The
PrtDevMode and PrtDevNames properties work with copies of
the DEVMODE and DEVNAMES data structures that are used
internally by Microsoft Windows® to provide information
about printer settings. The PrtMip property works with the
data structure that Access stores with a form or report
when printer settings are saved with those database
objects. While these properties provide a high degree of
detail and control, they can be difficult to use because
instead of providing a standard Visual Basic® object model
to work with, each property returns all of its members as
a single array of bytes that your code must carefully
parse. While these properties are still supported, in
response to developer requests for a better object model
for working with printer settings, Access 2002 provides a
new Printers collection and Printer object with a rich set
of properties for retrieving and setting printer
information. These properties are much simpler to use than
working with the PrtDevMode, PrtDevNames, and PrtMip
properties.

Additionally, because the PrtDevMode, PrtDevNames, and
PrtMip properties are available only when a form or report
is open in Design View, it is not possible to use them
from Access applications saved as .mde or .ade files or
from Access runtime applications because those file types
don't support opening forms and reports in Design View.
However, the new Printers collection and
Application.Printer object are available whenever Access
or a database application is open for working with the
default printer settings of all database objects, and the
Printer objects of forms and reports are available in all
view.

http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnacc2k2/html/ODC_acc10_Printers.asp

>.
>

[vMike]

I am not sure exactly what you are trying to do, but you might look into a
subform on your report for the other layout. I you want to change
orientation or something like that you need the prtdev mess. Hope this
helps.

"Mary" <mmic...@rochester.rr.com> wrote in message
news:1070001c25b49$0fb781e0$37ef2ecf@TKMSFTNGXA13...