Page Number Question

R

r. howell

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.
 
R

r. howell

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...
 
Top