Forcing Page Break

G

Gkins3

I have created a form for work that has a drop down menu consisting of each
department name (for sake of argument labeled 1, 2, 3, 4, and 5). Based off
the information in the form, I have created a 2 column report. Everything
works out well however I am attempted to force a page break at the end of
departments information. Rather than saying IF this field equals this make a
page break, I need it to only make a page break once the field name changes.

Can anyone help? And I thank you in advance for your assistance.

George K
 
A

Allen Browne

In report design view, open the Sorting And Grouping dialog.

Choose the department field, and in the lower pane of the dialog, choose Yes
for Group Header. Access adds a new Department Group Header (grey bar) to
report design.

Right-click the Department Group Header, and choose Properties. Set the
Force New Page property to
before section
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unwanted page break 5
page break 4
page break in report 4
Creating group/page break in Access 2003 0
Is there a way to force page break for groups? 2
page break 1
Help on page break 2
Force a page break in code 6

Top