Control visability of Label on a report

[Dave]

I have a label box on a report that I have set as Visable=NO.
However when a check box on the form generating the report is checked I want
to change the visability of that label on the report to YES.

Hope I said that clearly enough.

Any help here will be appreciated.

Thanks in advance

Dave

 

[Mr. B]

I have a label box on a report that I have set as Visable=NO.
However when a check box on the form generating the report is checked I want
to change the visability of that label on the report to YES.

Hope I said that clearly enough.

Any help here will be appreciated.

Thanks in advance

Dave

Hi, Dave,

Use the On Format event in the section of your report where the label
appears for you code.

You will have to fully reference the control on your form that has the
checkbox, something like (air code but pretty close):

if Forms![NameOfYourForm]![NameOfChkBox] = true then
me.NameOfLabel.visible = true
else
me.NameOfLabel.visible = false
end if

HTH

Mr. B

 

[Dave]

Its a beautiful thing.

Did not see an "On Format" event for the Report but I put it in the "On
Open" even of the report and it works great.

Thanks - much appreciated

Dave