page numbers in report restart per record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get the page numbers to restart (1 of __) for each record in a
report? Right now each record in the report is about 3 pages, which is fine,
but when doing several records the first record says 1 of 6 instead of 1 of
3. Thanks.
 
Hi Shannon,

Put your Page textbox in the footer for the record rather than the page
footer.

HTH
 
Larry, I tried that, but it's still saying 3 of 5, 4 of 5, 5 of 5 after the
record. Maybe I'm missing something. Shannon
 
Mark, I tried this, but nothing happened. I am a beginner user so I'm a
little lost with "code", but I copied and pasted and changed the
Me!Salesperson to the ID for the table. I haven't grouped anything, I just
want page numbers for each record, instead of all records. I appreciate the
help, but I'm afraid this is way over my head. Shannon
 
Shannon, I have used this code and it works quite well. Be sure to read the
instructions very carefully. You may have missed the instruction about
placing Me!ctlGrpPages in the footer. Add an unbound text box to the footer
and name it ctlGrpPages. To insert the code, in Report design view click
View > Code, go to the top of the code window, delete "Option Compare
Database" (since it is already in the code provided), and paste the code.
The code numbers pages within a group, so unless you group your records the
code has nothing on which to work. Click View > Sorting and Grouping, and
group by the primary key field. See Help as needed for more information on
Grouping. Check the code carefully to be sure you have replaced all of the
sample control names with your actual control names. Four lines from the
bottom of the code is a line that starts Me!ctlGrpPages =. Change what is in
quotes on that line to alter what will appear. As the code stands it will
read "Group Page 1 of 2". If you remove the word Group you will see "Page 1
of 2".
 
Hi Shannon,

I wasn't paying full attention when I read your post and gave you some
misinformation. Sorry. You've been getting better info from Bruce.
Disregard my earlier post.
 
Back
Top