Subreport with no data.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subreport that will have no data sometimes. I would still like the labels to show up even if there is no data from the query. How can I do this

Thanks
 
Josh said:
I have a subreport that will have no data sometimes. I would still like the labels to show up even if there is no data from the query. How can I do this?
Click to expand...


Place the controls you want to appear (when the subreport is
empty) on the main report in the same area as the subreport.

Then use code in the Format event of the main report section
that contains the subreport to make those controls visible
or not as needed:

Dim bolVisible As Boolean
bolVisible = Not Me.subreportcontrol.HasData
Me.lbl1.Visible = bolVisible
Me.lbl2.Visible = bolVisible
. . .
 
You must log in or register to reply here.

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

Vanishing subreports 1
Programming subreport to only give certain amount of data 6
If subreport has no data return "None" 1
Subreports Don't Display 5
Subreport and Header Empty 1
Help with subreport labels 2
Access How to prevent subReport from breaking across pages? 1
Hide Subreport on No Data 8

Back
Top