By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,079 Members | 1,788 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,079 IT Pros & Developers. It's quick & easy.

Can Access 2000 set something like page break in Report?

P: 48
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.
Apr 10 '08 #1
Share this Question
Share on Google+
4 Replies


Expert Mod 2.5K+
P: 2,545
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
Attached Images
File Type: jpg ScreenHunter_6.jpg (6.2 KB, 197 views)
Apr 10 '08 #2

P: 48
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
Apr 11 '08 #3

Expert Mod 2.5K+
P: 2,545
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
Attached Images
 
Attached Images
File Type: jpg ScreenHunter_8.jpg (10.2 KB, 176 views)
Apr 11 '08 #4

P: 48
Yes!! Thanks a lot Stewart! It works! :)
Apr 11 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.