Resetting page numbering after each group

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
 
G

Guest

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

Thanks,
Jame
 
G

Guest

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
 
G

Guest

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top