By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,467 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

Hide label for page number < 3

P: n/a
Jim
I have a report that needs disclamers at the bottom of each page
except the first two. The discamer is in the form of a label in the
page footer.

I tried adding this line to the page footer event "On Format"

=IIf([Page]<3,lbldisclamer.Visible=No,lbldisclamer.Visible=Ye s)

I was trying to hide a the lable "lbldisclamer" on the report where
the page number was less then 3?

It didn't work.....

Any Ideas?

Jim

Thanks in advance for you time
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 3 Mar 2004 14:24:35 -0800, Jim wrote:
I have a report that needs disclamers at the bottom of each page
except the first two. The discamer is in the form of a label in the
page footer.

I tried adding this line to the page footer event "On Format"

=IIf([Page]<3,lbldisclamer.Visible=No,lbldisclamer.Visible=Ye s)

I was trying to hide a the lable "lbldisclamer" on the report where
the page number was less then 3?

It didn't work.....

Any Ideas?

Jim

Thanks in advance for you time


Code the page footer format event:
[lblDisclaimer].Visible = [Page] < 3
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 12 '05 #2

P: n/a
Jim wrote:
I have a report that needs disclamers at the bottom of each page
except the first two. The discamer is in the form of a label in the
page footer.

I tried adding this line to the page footer event "On Format"

=IIf([Page]<3,lbldisclamer.Visible=No,lbldisclamer.Visible=Ye s)

I was trying to hide a the lable "lbldisclamer" on the report where
the page number was less then 3?

It didn't work.....

Any Ideas?

Jim

Thanks in advance for you time


You might have had better luck using a textbox wit hthe controlsource:
=IIf([Page]<3,"",[anothertextbox])

then put your disclaimer in anothertextbox and make it invisible.

What you did up there was try to evaluate whether a label was visible or
not. If you still want to use the VBA method then a simple:

lblDisclaimer.Visible = Me.Page < 3

--
But why is the Rum gone?
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.