What is Page Break Control?

Use page breaks to control where a page ends and where a new page begins. Insert a page break. Place the cursor where you want to start a new page. Select Insert > Page Break.

How do I edit a report in Access?

Add or edit a report title

1. On the Design tab, in the Header/Footer group, click Title.
2. When the label is created, the text in the label is selected for you so that if you want to change the text, you can just begin typing the title you want.
3. Press ENTER when you have finished.

How do I resize a report in Access?

Press [Shift] while you select each report label control you want to resize. Go to Format | Size | To fit.

What to do if access report page breaks?

It is RARE that you need to use the PageBreak control. Delete all of them. Then use various properties at the report and group level to make the report show what you need. Properties include Page Header, Page Footer, Keep Together. But don’t go overboard. Most reports work just fine without fiddling with these properties.

How do I Break a report into sections?

First, go to the Design View of the Report. As you can see at the bottom, it is grouped by Department and then grouped by Section. Click on Dept Header, in the Property page, set the Force New Page property to Before Section Alternative, click on the Dept Footer, in the Property page, set the Force New Page property to After Section.

Where do I find the page break control?

Page breaks can be viewed in Print preview but not in Report view or Layout view. Select the page break control, and then press the Delete key. Some report designs are best when displayed with each group starting on a new page. You can create this format by using the Force New Page property to force a page break every time the group value changes.

How to eliminate blank pages in your access report?

Open the report in Design view. Click on the right border of any control that extends beyond the eight-inch right margin mark and drag it to the left so the control is within the margin. Repeat step 2 for each control extending beyond the margin. Go to File | Page Setup.