Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3153
  • Last Modified:

Blank last page when using "Force new Page" in group footer

Hello,

I've got an access 2010 db that is printing an extra blank page at the end.  I'm using "Force new Page" in group footer as each group needs to be on it's own page.  Please help.

Thanks
0
eshurak
Asked:
eshurak
1 Solution
 
LucasCommented:
Check your margin settings.  I usually put them all to 0.25 and then my page width i can go as far as 8.5 in portrait mode.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

  Is the last group on it's own page?

Jim.
0
 
eshurakAuthor Commented:
It's not the margins.  The problem disappears when I don't use "Force new page" after the group.  This is a new problem since upgrading to 2010.
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
eshurakAuthor Commented:
Hi Jim,

The last page is totally blank except for the page header and footer.  The group footer that is set to "Force New Page after" is also set to not visible.
0
 
Jeffrey CoachmanCommented:
Not 100% sure about 2010...
But try something like this on Format event of the Group footer:

Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer)
Dim lngKeyPage As Long
lngKeyPage = Pages - 1
    If Page = lngKeyPage Then
        Me.Section("GroupFooter1").ForceNewPage = False
    End If
End Sub


The Report must be opened in "Print Preview" explicitly in order for this to work
1
 
Jeffrey CoachmanCommented:
Notes:

1. Not really sure, but set the Visible property of the section back to: True
2. If you need a Grand Total then you may have to add a running sum field and hide it on every page but the last (Key) Page...?
3 < I'm using "Force new Page" in group footer as each group needs to be on it's own page. >
To be clear, this setting makes sure that each group "Starts" on a new page, ...it cant force 300 records (if this is how many records a group has) to magically "Fit" on one page.

JeffCoachman
0
 
Jeffrey CoachmanCommented:
try this,
...the Page count is off by one though...

I'm swamped right now, so if another Expert has time to tweak this, or has a more elegant fix, feel free...
Database76.mdb
0
 
eshurakAuthor Commented:
Wow, thanks Boag for all your suggestions, but none of them really did the trick.  I played around with grouping and force new page setting and found the by setting the group footer force new page to after selection I did not get the extra page any more.  I also changed it to "Do not keep group together on one page".  I'm not sure what the silver bullet does, but I was able to do it without code (even on the sample the you sent me as well).

Thanks again.
0
 
eshurakAuthor Commented:
I hate not giving points to people but I want people who are searching EE in the future to be able to find answers.
0
 
Jeffrey CoachmanCommented:
<I hate not giving points to people but I want people who are searching EE in the future to be able to find answers.>
Other members searching here should be your only concern.
You solved your own issue and you stated how you did it.
So in this regard, think of yourself as the "Expert" who answered the question.

Good Work

;-)

Jeff
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now