Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional Text Box Syntax in a Report

Status
Not open for further replies.

OPathMan

Technical User
Dec 14, 2003
6
US
I want to have a message displayed only on the first page of a mutltipage report (and not visible if the report only consisits of one page). I have tried:

=IIf([Page]>1,“Continued on next page”)

I know I need more specifics, but am unsure of the syntax. Any help is greatly appreciated.
 
If this is going on the bottom of the first page, you might be able to do something like this:

WhilePrintingRecords;
If (PageNumber = 1) and (not NextIsNull({some data field}) then 'Continued on next page'

You only want this to happen on the first page (PageNumber = 1) and where there is still data to print (hence the check for not NextIsNull)

-D
 
You could use the following formula for a message to appear on every page but the last, and only on page 1 if there is more than one page:

if pagenumber < totalpagecount then &quot;Continued on Next Page&quot; else &quot;&quot;

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top