I have a report in Access 2007 that I am trying to force page breaks

[Sharon Brennan]

I would like to divide my report by our departments and then sites. I've gone into properties for each of my sorts and put in page breaks but nothing happens. Everything just runs together on one long report. I need to send the report to the different sites. I was able to do this in Access 2000 but am not able to get it to work in 2007.

[jimatqsi]

What I have done in prior Access versions is to add a footer for my sort item and put a page break after whatever I am printing in the footer. You can find page breaks on the toolbox toolbar.

I don't see a page break property in prior Access versions.

Jim