Subreport groupheader appears although there are no records tot sh

W

Weijland53

In access 2007 subreport headers appear although there are no records.
This was not the case within access 2003. Now my reports look a little silly
since in my reports I sometimes have subreports containing no data. I do not
want to see their headers then.
Doe somebody no how to re create the former functionality?
 
D

Duane Hookom

I wasn't aware this had changed. You could try add a text box to the Header
section:
Name: txtCount
Control Source: =Count(*)
Visible: No
Then in the On Format event of the section, add code (in the module window)
of:
Cancel = (Me.txtCount=0)
 

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

Top