Forcing a page break at the change of a field

[dabowles]

Hi,
How do you force a page break, or where do I need to put a page break control, in order to force a page break each time a text box control changes to a different number. For example I have this report here that is printing off every note an employee enters into this database here. I right now have the report printing out every single note continuously and when the employee's name changes it continues to print the next client's notes on the same page as the last employee name. What I want it to do is page break whenever the employee name changes. I have the following headers/footers setup maybe you can tell me where it should be at:
Report Header-Contains Nothing
Page Header-Contains Employee Name
Detail-Contains Notes
Page Footer-Contains Page Number of Report
Report Footer-Contains Nothing

Thanks for your time,
Dave Bowles

 

[CosmoKramer]

Dave,

You should probably move Employee Name from the Page header to its own Group header. See Access Help on "Sorting and Grouping". From there you can set the parameters do perform your page breaks on Employee name.....

 

[JoeMiller]

Dave,

Cosmo's idea is good because you can use the grouping mechanism built into Access to break to a new page every time your employee name group changes. I just wanted to tell you that you don't HAVE to move the employee name to the page header for the break to move. It's a preference thing really. You don't even have to give the headers any "space" on the page. You just need them to tell Access when the page breaks.

HTH Joe Miller
joe.miller@flotech.net

 

[1510982]

Hi. Hey, Joe!
"You just need them to tell Access when the page breaks."

So, tell us

Regards