Resetting page numbering after each group

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

Guest

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
 
Can you tell me how you reset after each school? I am trying to do the exact
same thing.

Thanks,
Jame
 
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
 
I am assuming this is a macro (cringe) that is set to run "On Format" in the
header of the section?
 
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
 
Back
Top