Page Break In The Details Section OF Report

  • Thread starter Thread starter billy_pit
  • Start date Start date
B

billy_pit

Hi,
I have one project in MS Access.
In that I have one form in which I am using one combobox and one
search button.
Now when I select an item from that combobox and press the submit
button then it will generate the report base on the selection of
combobox.
Now that report is generated by the using wizard whose source code is
Table PRODCUTION.
Now when I search and if there are more than 20 line in report than I
want to force new page and next 20 line must come in new page.Rest
like that.
I want to put this page break in Details section of the Report.

Plz Reply as soon as possible.
Thanks.
 
Can't you make the section heights in your report to values that
automatically break pages after 20 records? If not, you can place a page
break at the bottom of the detail section and add a text box to the detail
section:
Name: txtCountRecords
Control Source: =1
Running Sum: Over All
Visible: No
Then add code to the On Format event of the detail section:
Me.[Page Break Control Name].Visible = (txtCountRecords Mod 20 = 0)
 
Back
Top