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!

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

Omit page from a report

Status
Not open for further replies.
bill1856

bill1856

Programmer
Sep 5, 2005
18
US
I have a report that is four pages long. One of the pages (page 3 of 4) is only for 'Additional Info'. 90% of the time there is no additional info. Is there any way to not print that page unless there is data in the 'additional info' text box on the page?
 
Sort by date Sort by votes
How are you forcing the page throw? (Section properties or pagebreak controls?)
 
Upvote 0 Downvote
You can set the pagebreak control Visible property to false and it will not operate.

In the section Format event procedure test for a value and then set the visible property accordingly.

if isnull(me.mycontrol) then
me.pagebreakx.visible = false
else
me.pagebreakx.visible = true
end if

You need the canshrink property set in the additional info control.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PrimoSteve
  • Locked
  • Question
Grid From 1
2
Replies
21
Views
1K
PrimoSteve
PrimoSteve
TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
447
TomSalvato
TomSalvato
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
376
PrimoSteve
PrimoSteve
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
440
TrekBiker
TrekBiker
Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
1K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top