Displaying page numbers on a label, ms access reports

  • Thread starter Thread starter alex
  • Start date Start date
A

alex

hello community,

Can somebody tell me if i can display page numbers on a
label for my report in access. I use labels because i want
to export my report to Excel and if it's a text box for
page numbering,then it gets exported to .xls sheet as a
separate column, whereas labels don't.

In my source code i go
Me.lblPage.Caption = "Page " & [Page], but it displays the
same number on all pages

Please help :(
 
alex said:
Can somebody tell me if i can display page numbers on a
label for my report in access. I use labels because i want
to export my report to Excel and if it's a text box for
page numbering,then it gets exported to .xls sheet as a
separate column, whereas labels don't.

In my source code i go
Me.lblPage.Caption = "Page " & [Page], but it displays the
same number on all pages
Click to expand...

Do you have that code in the section's Print event?
 
-----Original Message-----
alex said:
Can somebody tell me if i can display page numbers on a
label for my report in access. I use labels because i want
to export my report to Excel and if it's a text box for
page numbering,then it gets exported to .xls sheet as a
separate column, whereas labels don't.

In my source code i go
Me.lblPage.Caption = "Page " & [Page], but it displays the
same number on all pages
Click to expand...

Do you have that code in the section's Print event?
Click to expand...
nope, i have it in my On Report Open event
 
-----Original Message-----
alex said:
Can somebody tell me if i can display page numbers on a
label for my report in access. I use labels because i want
to export my report to Excel and if it's a text box for
page numbering,then it gets exported to .xls sheet as a
separate column, whereas labels don't.

In my source code i go
Me.lblPage.Caption = "Page " & [Page], but it displays the
same number on all pages
Click to expand...

Do you have that code in the section's Print event?
Click to expand...
nope, i have it in my On Report Open event
Click to expand...

The page number is not known until the print event. If you
were setting a text box's ControlSource instead of a label's
Caption, it would have been almost ok. But a lable doesn't
calculate anything so you have to update the Caption
everytime the label section's is printed.
 
Back
Top