I WANT REPORT OF ADDRESS DATABASE

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 ?

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.

--
Rick B



"Kutty" wrote in message
...
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 ?

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.

Originally Posted by 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 ?