Hiding Page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lena - 07 Oct 2004 20:57 GMT

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?

Reply to this Message

Marshall Barton - 08 Oct 2004 00:40 GMT

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

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")

Signature

Marsh
MVP [MS Access]

Reply to this Message

Lena - 12 Oct 2004 13:57 GMT

> >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
[quoted text clipped - 6 lines]
>
> Me.Section(2).Visible = (Me.[patientcountry] = "US")

If I put it in a footer will my parent/child between the detail section and
my subreport still work?

Reply to this Message

Marshall Barton - 12 Oct 2004 16:29 GMT

>> >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
[quoted text clipped - 9 lines]
>If I put it in a footer will my parent/child between the detail section and
>my subreport still work?

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

Signature

Marsh
MVP [MS Access]

Reply to this Message