I WANT REPORT OF ADDRESS DATABASE

K

Kutty

I have created an address database. In form I have inserted a print control
thru wizard. Once I click that icon giving report of multiple pages. I need
single page. Where can I get the facility for this in property of print
control ?

[email protected]
 
R

Rick B

Not sure what you mean. If the report is longer than one page, it will take
more than one page to produce it.

More details please.
 
B

Bob Miller

Try this:
DoCmd.OpenReport "Report", acViewPreview, "", "", acNormal
DoCmd.PrintOut acPages, 2, 2, acHigh, 1, True
to print out page 2 of the report. Replace the 2,2 with the page
number you want to print.
If you want to pick the pages to print you could replace the 2's with
variables or delete the second line and use the Access Menu Print that
allows you to select pages to print.
 
Top