If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
The value of [Pages] is incorrect
I have a report which has code in one of the group headers that forces new pages under certain conditions. This has caused the = [Page] & " of " & [Pages] in the page footer to show too few pages in the report. i.e. You can start on (Page 1 of 22) and end on (Page 28 of 22). I was wondering if there was a way to force the number of pages to be re-counted?
If not; is there any way to move to the last page of the report and get the [Page] value when the report reformats based on grouping conditions and then update the Page of Pages text box? Any advice is appreciated. Michael |
#2
|
|||
|
|||
The value of [Pages] is incorrect
I figured something out. I kept track of the pages detail section.
|
#3
|
|||
|
|||
The value of [Pages] is incorrect
Is your code in the On Format event or in the On Print event? I suspect the
latter and would recommend that you try moving the code to the On Format event. Michael wrote: I have a report which has code in one of the group headers that forces new pages under certain conditions. This has caused the = [Page] & " of " & [Pages] in the page footer to show too few pages in the report. i.e. You can start on (Page 1 of 22) and end on (Page 28 of 22). I was wondering if there was a way to force the number of pages to be re-counted? If not; is there any way to move to the last page of the report and get the [Page] value when the report reformats based on grouping conditions and then update the Page of Pages text box? Any advice is appreciated. Michael |
Thread Tools | |
Display Modes | |
|
|