limit date range in 3 slips per page

[Guest]

I'm using the report template from Allen Browne's site for 3 mailing slips
per page. Now I'm trying to limit the date range of the report. When I add
the txtStartDate and txtEndDate text boxes in the report header, the third
slip moves to page 2.

I've also tried using Allen's frmCalendar on my main form to limit the date
range for the reports. I wasn't successful with that method either, although
it looks like a cleaner way to accomplish the task.

 

[Allen Browne]

Presumably you are talking about this page:
Print a page with 3 evenly spaced mailing slips
at:
http://allenbrowne.com/ser-54.html

If you have a Page Header to add to the report, you will need to decrease
the height of the Detail section to allow it to fit on the page. If you want
the 3 slips to still be equal spacing, you will also need to increase the
height of the divider section between the pages.

If you want the 3 slips the same (so the page number is on each one), it
would be easier to put the text box on each label instead of using the Page
Header section.

If you want each label to count as a different "page" number, just add a
text box with properties:
Control Source =1
Running Sum Over All

To filter a form by date, see:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

You can still use the popup calendar form from:
http://allenbrowne.com/ser-51.html
to set the values of those text boxes on your form.