Printing reports - each record new sheet

[Johnette]

Greetings, all

I have a database of historic properties, and we are printing survey forms for each property within a municipality. Since there is a lot of data, we want to print them double-sided. However, when we do that using the regular print menu, new records may print beginning on the back page of the previous record. How do I get each new record to begin on a new sheet of paper? THAT is the challenge!

Thanks so much for your help!
- Johnette

 

[boblarson]

If you have any groupings, you can set Force New Sheet to Yes in the Report's group properties. If you don't and you truly want a new shee after each detail, you can set the Detail sections Force New Sheet to Yes.

 

[Johnette]

Hello, Bob

This sounds very promising! However, I have never seen a "Force New Sheet" property. I have Access 2000, and I looked in the report properties and in the report's "sorting and grouping" properties, and I don't see it.
I want to start a new sheet after each report (each historic property). Currently, I only have the report sorting by an Inventory number; I don't have any grouping assigned for the overall report.

- Johnette

 

[boblarson]

I have 2000 as well, and it is located:

 

[Johnette]

A-ha!

Thanks for so pointing that out so nicely. However... having tried that out, I think I'm further understanding my issue.

While that nifty item does force a new page, it does not force that new page onto a new piece of paper. Additionally, the Force New Page property isn't available for all report segments (not for page header or footer). I think I need two things:

1. I need each historic property (record) to be calculated as a separate report, so that my report header shows up for each historic property.
2. I need each record to begin on a new sheet of paper. I think it might do that if I can accomplish item #1.

Here is an example scenario: The client wants to print all of the survey forms for one municipality in their county - there could be one or 50 individual survey forms. The way I have it set up now, when you open the report (which selects records from a query based on a dialog box), it print previews all the survey forms for that town, and you print from there. Each survey form has its own report header, footer, detail, etc. We would like to be able to print (double sided) such that each survey form begins on its own sheet of paper.

Any thoughts?

Thanks again
- Johnette

 

[boblarson]

For #1 - put your header that you want on each page in the group header instead of report header as the report header will ONLY print once for each report.

For #2 - put a page break (selected on the controls toolbar) in the group footer (if you don't have a group footer, go to View > Sorting and Grouping and add one)

1. Make sure you have a group footer:

2. Select the Page Break control

3. Place it on the form

4. close up the footer so only the page break is taking up space.

 

[Johnette]

Hi, Bob

Alright, I got rid of the report header/footer, moved the header info into a new group header, applied the page break, etc., per your suggestion. Now the info in the group header, with or without the "Force New Page" enabled, shows up on its own page for each record. Not quite what I was hoping for! I also tried removing that page break, but that didn't seem to help.

I have seen a "printing loop" mentioned somewhere, but I haven't seen any examples of that. Does this sound familiar to you? If so, do you think it might help?

Thanks!
- Johnette

 

[boblarson]

Can you post a copy of your database here? Go to Tools > Database Tools > Compact and Repair and run the compact. Then, zip the mdb file into a zip file using WinZip, or similar and then post here using the Manage Attachments button which can be accessed by clicking on the Go Advanced below under the quick post window. The file size AFTER compacting and AFTER ZIPPING needs to be 393Kb or less.

 

[Johnette]

Unfortunately, it is over 2MB when compacted and zipped.

 

[boblarson]

I'll PM you with an email address at which you can send it to me.

 

[Johnette]

Ok, thanks!

 

[NikB]

Did you ever get this sorted? I need to do the same.

 

[Johnette]

No, I never did, unfortunately. Let me know if you figure it out. Good luck!!

 

[NikB]

I have used the following work-around to print duplex reports, starting a new section on a new SHEET (ie an odd page number). It is based around a suggestion on the following link:

http://www.access-programmers.co.uk/forums/showthread.php?t=23783

I used the following Event Procedure in the Group Footer OnFormat property:

Private Sub GroupFooter2_Format(Cancel As Integer, FormatCount As Integer)
'If the last page of the category is odd:
If (Me.Page / 2) = (Me.Page \ 2) Then
'alternatively use the next line which achieves the same as the line above:
'If (Me.Page / 2) = Fix(Me.Page / 2) Then
Blank_Page_Box1.Visible = False
Blank_Page_Box1 = ""
Else
'If the page number is even:
Blank_Page_Box1.Visible = True
Blank_Page_Box1 = "This blank page is inserted intentionally to accommodate duplex printing."
End If
End Sub

"Page" is a control on the report calculating the page number for each section of the report (not for the report as a whole).
"Blank_Page_Box1" is a control in the last Group Footer on the report. It has the following properties: Visible: No, Vertical: Yes, Can Shrink: Yes, Can Grow: Yes. The height is set to +/- the height of the page being printed and the font size set appropriately to fill the text box height.

Set the properties of the Group Footer containing Blank_Page_Box1 to: Can Grow: No, Can Shrink: Yes

 

[Johnette]

NikB,

Thanks for forwarding this tip - I appreciate it! Hopefully I'll get my head back into that database and give it a try soon. I don't have any group footers in my reports, but I may be able to craft something based on your suggestion.

Thanks again,
- Johnette