How do I number pages in Access report..100 page report in 20 sec.

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

Guest

I have a report that consists of 20 cases. When printed, I would prefer each
case be numbered independently as Page 1- Page 5. Is there a way to force
Access to do this? Thanks
 
Susan,

Not by itself. That is how I insert page numbers in the report, but all I
get is Page 1-Page 100, not each case numbered Page 1-Page 5. Did I miss
something simple?

Thanks.
 
Is each case on a separate page?


If not, then you need to break the page after each case.
 
Herman:

I typed the code in. I assume it is to be typed exactly as written. Or was
I supposed to change anything to meet my data? It is unclear as to the name
of the control. It is written as: Me!ctlGrpPages Is this right? No =
before it?

Thanks,

Ron
 
Hermie, Have you used this code? The author says that Access will format the
report twice to get the total number of pages, but it doesn't seem to make a
second pass (me.pages is always = 0). Any ideas? I can get the page number
but not the number of pages w/in the group since it isn't making the second
pass.

-Mark
 
Hermie, Have you used this code? The author says that Access will format the
report twice to get the total number of pages, but it doesn't seem to make a
second pass (me.pages is always = 0). Any ideas? I can get the page number
but not the number of pages w/in the group since it isn't making the second
pass.

-Mark
Click to expand...

Access reports do not calculate Pages unless you add a control telling
it to do so.
Did you add an unbound control to the Page Footer with it's control
source set to
=[Pages]
 
Thanks Fred, that's all I needed to do!


fredg said:
Hermie, Have you used this code? The author says that Access will format the
report twice to get the total number of pages, but it doesn't seem to make a
second pass (me.pages is always = 0). Any ideas? I can get the page number
but not the number of pages w/in the group since it isn't making the second
pass.

-Mark
Click to expand...

Access reports do not calculate Pages unless you add a control telling
it to do so.
Did you add an unbound control to the Page Footer with it's control
source set to
=[Pages]
Click to expand...
 
Back
Top