Page header problem

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

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

Do you have CanShrink on the controls?
-Tom.

Quote:

>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
>

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

Regards

"Tom van Stiphout" <no.spam.tom7744@cox.netwrote in message
news:nic6i2ppgf9dnkab7n67o26ktkoni04utt@4ax.com...

Quote:

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

Quote:

>>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 wrote:

Quote:

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

Page header problem

re: Page header problem

re: Page header problem

re: Page header problem

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about