Resetting page numbering after each group

P

Paul Doree

Hi,

I'm grouping on School Name, and want to reset the page numbers back to 1
after each school. I've managed this, but now need to also reset the Pages
value (e.g. I have 345 pages on the report, but want the pages value to also
reset to 1 after each school. Access is telling me the Pages value is read
only.

Anyone know a way to do this?

Paul
 
J

Jamie A Miller

Can you tell me how you reset after each school? I am trying to do the exact
same thing.

Thanks,
Jame
 
P

Paul Doree

Jamie,

Apologies for late reply. I did it by resetting the page property in the
report header:

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
Page = 1
End Sub
 
J

Jamie A Miller

I am assuming this is a macro (cringe) that is set to run "On Format" in the
header of the section?
 
P

Paul Doree

Hi Jamie,

It's visual basic in the on format event of the group header.

Click on the grey header bar in the report which is the group header you
wish to reset the page number for. in the properties go to the Event tab and
then the 'On Format' event. Choose the visual basic option and enter:

Page = 1

in the sub routine for the GroupHeader
 
Top