Hiding Page

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

Guest

In my database I have Canadian and US patients. For US patients I want to
hide the final page of a report, on that page are a graphic, a few labels and
a sub-report. Some of the items don't have sources so I can't use IIF in the
source. Is there a way I can do this?
 
Lena said:
In my database I have Canadian and US patients. For US patients I want to
hide the final page of a report, on that page are a graphic, a few labels and
a sub-report. Some of the items don't have sources so I can't use IIF in the
source.
Click to expand...


You can't make a page invisible, but you can make a section
invisible. If all the suff you want to hide in in the
report footer then use its Format event:

Me.Section(2).Visible = (Me.[patientcountry] = "US")
 
Marshall Barton said:
Lena said:
In my database I have Canadian and US patients. For US patients I want to
hide the final page of a report, on that page are a graphic, a few labels and
a sub-report. Some of the items don't have sources so I can't use IIF in the
source.
Click to expand...


You can't make a page invisible, but you can make a section
invisible. If all the suff you want to hide in in the
report footer then use its Format event:

Me.Section(2).Visible = (Me.[patientcountry] = "US")
Click to expand...
If I put it in a footer will my parent/child between the detail section and
my subreport still work?
 
Lena said:
Marshall Barton said:
You can't make a page invisible, but you can make a section
invisible. If all the suff you want to hide in in the
report footer then use its Format event:

Me.Section(2).Visible = (Me.[patientcountry] = "US")
Click to expand...
Click to expand...
Lena said:
If I put it in a footer will my parent/child between the detail section and
my subreport still work?
Click to expand...

As long as it's not a page footer, it should be ok.
 
Back
Top