Page header problem

[John]

Hi

On a report I need to display some controls on all pages except the first
page. I have added these controls to the page header of the report and in
the on format event am using the code;

If page =1 then
ctrl1.visible = false
...
else
ctrl1.visible = true
...
end if

The problem is that once controls are not visible the height of the page
header does not reduce (there is no can shrink property on page detail) and
hence there is a gap on the first page of report. How can I make sure that
if controls are not visible then page header shrinks accordingly?

Thanks

Regards

[Tom van Stiphout]

Re: Page header problem

On Wed, 4 Oct 2006 04:18:23 +0100, "John" <John@nospam.in fovis.co.uk>
wrote:

Do you have CanShrink on the controls?
-Tom.

>Hi
>
>On a report I need to display some controls on all pages except the first
>page. I have added these controls to the page header of the report and in
>the on format event am using the code;
>
>If page =1 then
ctrl1.visible = false
...
>else
ctrl1.visible = true
...
>end if
>
>The problem is that once controls are not visible the height of the page
>header does not reduce (there is no can shrink property on page detail) and
>hence there is a gap on the first page of report. How can I make sure that
>if controls are not visible then page header shrinks accordingly?
>
>Thanks
>
>Regards
>

[John]

Re: Page header problem

All except label and image controls. There is one each of these.

Regards

"Tom van Stiphout" <no.spam.tom774 4@cox.netwrote in message
news:nic6i2ppgf 9dnkab7n67o26kt koni04utt@4ax.c om...

On Wed, 4 Oct 2006 04:18:23 +0100, "John" <John@nospam.in fovis.co.uk>
wrote:
>
Do you have CanShrink on the controls?
-Tom.
>
>

>>Hi
>>
>>On a report I need to display some controls on all pages except the first
>>page. I have added these controls to the page header of the report and in
>>the on format event am using the code;
>>
>>If page =1 then
>ctrl1.visibl e = false
>...
>>else
>ctrl1.visibl e = true
>...
>>end if
>>
>>The problem is that once controls are not visible the height of the page
>>header does not reduce (there is no can shrink property on page detail)
>>and
>>hence there is a gap on the first page of report. How can I make sure that
>>if controls are not visible then page header shrinks accordingly?
>>
>>Thanks
>>
>>Regards
>>

>

[Rick Brandt]

Re: Page header problem

John wrote:

Hi
>
On a report I need to display some controls on all pages except the
first page. I have added these controls to the page header of the
report and in the on format event am using the code;
>
If page =1 then
ctrl1.visible = false
...
else
ctrl1.visible = true
...
end if
>
The problem is that once controls are not visible the height of the
page header does not reduce (there is no can shrink property on page
detail) and hence there is a gap on the first page of report. How can
I make sure that if controls are not visible then page header shrinks
accordingly?
Thanks
>
Regards

Set the PageHeader *property* of the report to "Not with Rpt Hdr". Then it is
not shown at all on the first page.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com