Microsoft Access Report Reset Page Number On Report Footer

Posted on 2016-09-01
Medium Priority
Last Modified: 2016-10-22
On last group record in a access report, the report shows page 1 of 2, the last page of the report shows 2 of 2 in the report footer, how do I reset the page number on the report footer to  page 1 of 1
Question by:rjordanbots
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 85
ID: 41780463
Why would you consider the LAST page of a 2 page report to be page "1 of 1". If it's a separate report, then create it as such.

That said: If the Report Footer page is always one page, then just use a static Label with a caption of "Page 1 of 1"
LVL 26

Accepted Solution

Nick67 earned 2000 total points
ID: 41780469
I don't quite understand.
[Page] of [Pages] is known as a notorious liar.

On last group record in a access report, the report shows page 1 of 2,
Ok, how many pages are there actually
the last page of the report shows 2 of 2 in the report footer,
Because this suggests two
how do I reset the page number on the report footer to  page 1 of 1
Well, you have no control over [Page] of [Pages]

You can try to keep track yourself by tracking Page() and Retreat() events, but that's the same thing Access does and fails to succeed at.
You can try to put a header/footer in a logical place on the report with a PageBreak control in that fires when a section above it grows to be almost to big to fit on the page (which is what causes the lies)  but getting that right is very hard.
You can render the entire report hidden.  Code in the report footer can then put the value of [Page] in a variable outside the report itself.  You then close the report and use [page] of [ThatStoredVariable] -- but you are essentially rendering the report twice for each time it outputs.

Or forget that notoriuos liar [Page] of [Pages] and just go with [Page]

I don't know of any simple joy, myself.
LVL 51

Expert Comment

by:Gustav Brock
ID: 41781426
In the group header, set:

    Me.Page = 1

LVL 51

Expert Comment

by:Gustav Brock
ID: 41847074
No response from the questioneer, so delete.

LVL 26

Expert Comment

ID: 41847105

Whack it.
The author never replied to any suggestions, or clairified the issue.

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

777 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