Can Access 2000 set something like page break in Report?

[HowHow]

I am using Access 2000 to create report. I need to print training history for every worker in my department.

Currently my report group the training record by worker's name but it continues with the next worker and his/her record on the same page.

I do not want to print each worker's training history by selecting the specific name using query in report one by one. This is because I need to print the training history for all the workers in my department for the first time and file them seperately in their personal file.

Is there anything like page break after each worker's last record? So that no matter how long or how short is the training history, it starts with new page for next worker.

[Stewart Ross]

Hi. Open your report in design view, right-click on the detail section (which prints the details of the training record for each staff member) and select Properties. Change the Force New Page property to After Section. This will force a page break after each record is printed.

A screenshot of the property is attached.

-Stewart

[HowHow]

Hi,

I cannot find the "Force New Page" in property. Is this function available for Access 2000?

Not sure how to attach the printscreen here but what I saw in Report/Design view/ Worker Name Field (right click)/ Property/All tab are:
Name........... ...........
Countrol Source.......
Format......... ...........
Decimal Places.......

Did I missed any step? Please show me how to get to Force New Page again if you don't mind. Thanks

[Stewart Ross]

Hi. You need the properties for the detail section itself, not for one of the controls within it. Right-click on the detail section separator bar or a blank area within the detail section of your report, then click on properties. See attached screenshot.

Also note that the properties tab will show that it is the detail section you are viewing if you have selected the correct item - see second screenshot.

-Stewart

[HowHow]

Yes!! Thanks a lot Stewart! It works! :)