Solved

Show/Hide page numbers in a report's Group section

Posted on 2001-09-04
3
221 Views
Last Modified: 2012-06-21
Background:  I have an Access 97 report that generates invoices for mailing.  A single report consists of several invoices that print as a single report.  Most invoices are only 1 page long, but the level of detail or formatting rules can result in more than one page for that individual invoice within the report.  There is no way of knowing ahead of time how many pages a given invoice will be.

I have page numbers showing on the bottom of each page.  By resetting .page = 1 in the GroupHeader_Format sub of the report I can correctly show the page numbers for all invoices in the report.  However, my client only wants page numbers to show when the individual invoice is more than one page.  The Pages property only keeps track of the total pages of the entire report.

Question:  Is there a way of knowing how many pages are in a single Group section of the report (a particular invoice) to use that number to test whether to hide or show the control displaying the page number for that Group section?  Seems to be a limitation in Access to have a forward look at that level of detail (anything less than the entire report).
0
Comment
Question by:garyw1
  • 2
3 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 50 total points
ID: 6454436
You can use the WillContinue property to see if a page will continue or not.

Jim.
0
 
LVL 57
ID: 6454448
Also, here is a MSKB article that show you how to do "page x of y" over a group.

http://support.microsoft.com/support/kb/articles/Q131/9/37.asp

Jim.
0
 

Author Comment

by:garyw1
ID: 6454985
Your suggestion looked to solve the problem, and it did for about 1/2 of the group sorts (invoices), but the other half didn't display correctly due to the way my repetitive detail section prints.  Also had problems finding enough documentation on WillContinue to know if there was any other syntax or a different section to use as the trigger.

The solution I have implemented uses a boolean variable to flag whether the last section of the invoice has printed - it will always only print on the last page.  The page footer checks this flag and shows visible when required.

Your suggestion, while not the solution I used, helped get me to the right support information to come up with the solution.  Thanks.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question