Change label formats on report

[D.W. Schingenga]

I would like to control the output on a report by the form. I would like to highlight an report item (through put a border around a lable) when an checkbox is checked on the form the report is called from.

Problem I encouter is that I can not change format properties of report items as with forms.

Please give me some directions on how to fix this.

Thanks,

Dirk

 

[sphere_monk]

Hi Dirk,

I just tried this and it works. Put a box around the label on the report and format it the way you want. Then go into the Open event of the Report and write "Me!<boxname>.Visible = False. When you open the report the box will not be visible. If you then go back into the report design mode and edit the statement you just entered to be True, when you run the report the box will be visible.

You can use the same logic to put a box around something if a checkbox on your form is checked. Just attach an If statement around the above statement that looks on your form for the value of your checkbox and makes the box visible accordingly.

Hope this helps,

Dan

 

[D.W. Schingenga]

Hi Dan,

Sorry for the late reply. Thanks, it works fine.

Dirk