report print

M

Meteoro

hi all! Im designing a report with a text box , but i have a problem with it

the text box has to appear or not , according to the number of pages of
the report:

a) if the report is an one-page report, ---> text box has to appear
b) if number of pages is over 1 page, ----> text box hasnt to appear in
page number 1, but it has to appear in the rest of pages.


any idea?? im really stuck!

thanks alot.


(I'd like to apologize for my english, im spanish).
 
F

fredg

hi all! Im designing a report with a text box , but i have a problem with it

the text box has to appear or not , according to the number of pages of
the report:

a) if the report is an one-page report, ---> text box has to appear
b) if number of pages is over 1 page, ----> text box hasnt to appear in
page number 1, but it has to appear in the rest of pages.

any idea?? im really stuck!

thanks alot.

(I'd like to apologize for my english, im spanish).
Click to expand...

Add a control to the page footer to calculate [Pages] if you don't
already have one:
=[Pages]
or
= "Page " & [Page] & " of " [Pages]

(You can make it not visible if you don't want to display it):

Code the Page Footer Format event:

If [Pages] = 1 Then
Me![TextControl].Visible = True
Elseif [Pages]>1 and [Page] >1 Then
[Me![TextControl].Visible = True
Else
Me![TextControl].Visible = False
End if
 
Top