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

R

Ron Fuller

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
 
R

Ron Fuller

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.
 
R

Rick B

Is each case on a separate page?


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

Ron Fuller

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
 
M

MarkJ

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
 
F

fredg

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]
 
M

MarkJ

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...
 
Top