Page Number

  • Thread starter Thread starter 123
  • Start date Start date
1

123

Thank you for your help and answer:

Page number:

Is there any way to control page number: The problem is page number is
numbering all the page of the report (but if I have group of data and every
group is separate in New page here I want to rest the page number to begin
the numbering from 1 and so on every group 1 to end of group)

Group header:

Force new page = before section mean every group will be in a page
 
123 said:
Page number:

Is there any way to control page number: The problem is page number is
numbering all the page of the report (but if I have group of data and every
group is separate in New page here I want to rest the page number to begin
the numbering from 1 and so on every group 1 to end of group)

Group header:

Force new page = before section mean every group will be in a page
Click to expand...


The way I do that is to use a text box named txtLineCount in
the detail section. Set its control source expression to =1
and RunningSum property to Over Group.

Now you can use this code in the Page Header's Format event:

If Me.txtLineCount = 1 Then
Me.Page = 1
End If
 
Thank you very much for your help
Excellent work:
If you could another question:
If I want use this expression for every group is this possible
="Page " & [Page] & " of " & [Pages]
For every group
thank you for your kind
 
123 said:
Thank you very much for your help
Excellent work:
If you could another question:
If I want use this expression for every group is this possible
="Page " & [Page] & " of " & [Pages]
For every group
Click to expand...


You should have said that's where you were going before.

Anyway, here's two articles on that topic
http://support.microsoft.com/default.aspx?scid=kb;en-us;306127&Product=acc

http://www.mvps.org/access/reports/rpt0013.htm

Personally, I think the second one is easier to implement.
 
Back
Top