Insert Page Break Control In Access. If you were to add one to the Details section of the Report you could use something like the following to perform the page break. Now go to Design View under Dept Footer insert a Page Break Control say PageBreak49.
Select Same Position to place the grid in the same position as it is currently placed. Click on the Format tab. Insert a page break control above any other controls in this group section you may need to move some controls down a bit.
So a page break will occur after all LastNames starting with A have been listed then after all LastNames starting with Band so on.
While vbCrLf vbCr and vbLf exist it is better to use vbNewLine. Next click on Depart Footer in the Property select Event On Format Code Builder. Select the group header you want to keep together with some text. As far as I test when we press the PAGE DOWN key the focus moves to the sub form on the second page.
