I have a query that creates the Return Address Label info and a report that prints it once, however, I need to print it multiple times (as many as there are entries in a different particular query result). It needs to fill the sheet (3 Columns and however many rows to completely fill the sheet then go to a new sheet until the number required is completed.
Return Address Labels for Christmas Cards, etc.
- Thread starter Bluzmail1
- Start date
Isskint
Slowly Developing
- Local time
- Today, 06:24
- Joined
- Apr 25, 2012
- Messages
- 1,302
Rather than print the form with DoCmd.Openreport rptName,AcViewNormal...
Open it first (either visible of not) an use the Docmd.PrintOut method which allows you to secify how many pages you want to print. As for columns of data, open your report in design view and go to the Columns tab of Page setup options (File>>Page Setups).
Open it first (either visible of not) an use the Docmd.PrintOut method which allows you to secify how many pages you want to print. As for columns of data, open your report in design view and go to the Columns tab of Page setup options (File>>Page Setups).
