not display report header when fields are empty

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have a report which uses three levels of grouping. The form layout looks
something like this:

PageHeader
[table1col1]
GroupHeader1
[table2col1]
[table2col2]
GroupHeader2
[table3col1]
[table3col2]
GroupHeader3
[table4col1]
[table4col2]

The record source of the report is actually a query which joins the values
of 4 different tables. Each GroupHeader in the report contains values from
one of those tables. For a particular record, if a top level header
contains no data, then a lower level header will be empty also.

Everything works fine excepts that when a particular group's records are
empty or null, i don't want the controls to display.

For example, here is a typical report for one of the records for the
"Galaxy" table.

Galaxy: MilkyWay --------------PageHeader
Star System: Solar system ------GroupHeader1
Planet: Earth ----------------GroupHeader2
Satellite: Moon ----------GroupHeader3
Planet: Saturn
Satellite: Mimas
Satellite: Tethys
Satellite: Dione
Satellite: Titan
Planet: Mercury
Satellite:
Star System: otherstarsystem
Planet:
Satellite:

I want the report to look like this, without the labels showing up when
there are no records in that group, and preferably without the headers
taking up any vertical space

Galaxy: MilkyWay
Star System: Solar system
Planet: Earth
Satellite: Moon
Planet: Saturn
Satellite: Mimas
Satellite: Tethys
Satellite: Dione
Satellite: Titan
Planet: Mercury
Star System: otherstarsystem

Is this possible ? Conditional formatting only works on textbox controls and
combobox controls (?) so that won't work. Any other methods someone can
suggest ?

Thanks

Chuck



.

Relevant Pages

  • Re: not display report header when fields are empty
    ... The record source of the report is actually a query which joins the values ... Satellite: Tethys ... Planet: Mercury ... Star System: otherstarsystem ...
    (microsoft.public.access.reports)
  • Re: not display report header when fields are empty
    ... then a lower level header will be empty also. ... Satellite: Tethys ... Planet: Mercury ... Star System: otherstarsystem ...
    (microsoft.public.access.reports)
  • Risks Digest 26.60
    ... ACM FORUM ON RISKS TO THE PUBLIC IN COMPUTERS AND RELATED SYSTEMS ... Massive Internet Outage blamed on Juniper routers ... NASA Confirms 'Suspicious Events' in Satellite Hacking Report ...
    (comp.risks)
  • Ecological credit crunch
    ... The Living Planet report calculates that humans are using 30% more ... on an "ecological footprint" of human demands for goods and services. ...
    (uk.philosophy.humanism)
  • Spysats: win some, lose some
    ... By Michael Fabey/ Aerospace Daily & Defense Report ... Commercial satellite imaging company GeoEye is on schedule to meet the ... GeoEye vice president of communications and marketing. ...
    (sci.space.policy)