Hiding specific detail controls when subreport has data

H

hornetsjaz

Basically, I have a main report and two subreports. When the one
subreport has data I want to hide certain controls on the main reports
detail. Likewise with the other subreport.

Any suggestions?

Thanks
 
D

Duane Hookom

You can use code in the On Format event of the section of the main report
like:

Me.txtCertainControl.Visible = (Me.srptOne.Report.HasData = False)
 
H

hornetsjaz

Thanks a bunch! That worked

Duane said:
You can use code in the On Format event of the section of the main report
like:

Me.txtCertainControl.Visible = (Me.srptOne.Report.HasData = False)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SynNeed to account for null values in subreports 2
Hide one subreport if other has data 1
Subreport with no records 8
Subreport page break in label controls or textbox controls 6
Removing Subreport from Main Report 2
Totalling SubReports - have tried and tried 7
Sub report expands even though Can Grow is no 3
Using Subreports to create a Main Report 7

Top