microsoft.public.access.reports

I think you need to check whether or not a control in the the Group header
has data or not.
Cancel = IsNull(Me.SomeControlName)

Of course that may fail with controls that are bound to images and you may
need a different test.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

"Theresa" wrote in message
news:77752076-4806-49A0-A516-71EA67784513@microsoft.com...
> Hi,
> I have a similar problem except I want to hide a group header if an image
> is
> not present. The situation is as follows:
> Report Header
> Group header 1 [this contains the image]
> Group header 2 [also contains an image]
> Details
> If there is no image in the group headers 1 or 2 I want them no to
> display.
> When I use the Cancel = Not Me.HasData the first record is hidden but then
> it does not change for the next record that does have an image.
> How do I force it to change for each record?
> Thanks.
> "Mona-ABE" wrote:
>
>> "freakazeud" wrote:
>>
>> > Hi,
>> > use the group headers on format event with:
>> >
>> > Cancel = Not Me.HasData
>> >
>