allow user to choose page break option for report

J

Janelle B

I have a report options screen which allows the user to
choose various options for the report. I'd like them to
be able to check a box which would create a page break
after each category. How do i do this in code? I know
that I can set the ForceNewPage to 'After Section' on the
report itself, but every time i try to do it in code it
doesn't work.

This is the code I currently have in Report_Open sub:

If Forms![frmrptr_req]![chkBreak] = True Then
Reports![rptRptr_Req].Section
(GroupFooter0).ForceNewPage = 2
Else
Reports![rptRptr_Req].Section
(GroupFooter0).ForceNewPage = 0
End If

What am i missing?

Any help would be greatly appreciated.

Thanks!

Janelle
 

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

Top