Page Number Question

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

Guest

Is there any way to make the page number, in the format page x of y, only
show up if there is more than one page in a report?

This is not the same thing as suppressing the number on the first page,
which I know I can do. If the report is more than one page, it's kind of
important that it say "Page 1 of 2", but if it is only one page, it would be
better not to have "Page 1 of 1". Classier, in the opinion of the powers
that be at my firm.
 
Many, many thanks. Getting the hang of this slowly but surely.

Duane Hookom said:
=IIf([Pages]>1,"Page " & [Page] & " of " & [Pages], Null)

--
Duane Hookom
MS Access MVP


r. howell said:
Is there any way to make the page number, in the format page x of y, only
show up if there is more than one page in a report?

This is not the same thing as suppressing the number on the first page,
which I know I can do. If the report is more than one page, it's kind of
important that it say "Page 1 of 2", but if it is only one page, it would
be
better not to have "Page 1 of 1". Classier, in the opinion of the powers
that be at my firm.
Click to expand...
Click to expand...
 
Back
Top