Problem with CanGrow field in Page Header

[Guest]

Hi,

I have an Access report that has a Page header with quite few data fields in
it. One of the fields is an address field which has the CanGrow property set
to YES.

The problem is that when this field grows, it moves all fields below it
down, so that now some of the fields start drop off the bottom of the page
header.
Is there a way to make the required field "grow" without affecting the
position of the other fields?

Rael

 

[Allen Browne]

No. If a control Can Grow, its vertical space increases, and the other
controls are pushed further down.

In most cases, you set the Can Grow property of the *section* as well as
that of the controls. However, the Page Header does not have a Can Grow
property. Therefore this doesn't work with a page header.

An alternative might be to use a Group Header with properties:
Repeat Section yes
Can Grow Yes
This replaces the page header, since it repeats on every page.

The section will need to be based on a field that doesn't change throughout
the report. You can achieve that by adding another field to the report's
query, e.g.:
AlwaysFalse: False

 

[Guest]

Absolute genius!!!
Thanks Allen

Always knew I could rely on some local knowledge.

Rael

 

[fredg]

Hi,

I have an Access report that has a Page header with quite few data fields in
it. One of the fields is an address field which has the CanGrow property set
to YES.

The problem is that when this field grows, it moves all fields below it
down, so that now some of the fields start drop off the bottom of the page
header.
Is there a way to make the required field "grow" without affecting the
position of the other fields?

Rael

How could a control "grow" without moving the other fields down?
If the other control didn't move down, the top control would hide the
lower control and you wouldn't see it's text.

If you wish to display lot's of text in a control without having the
next lower control lose it's position, size the upper control as tall
as required for the most data expected. Do not use Can Grow on this
control. The controls will then not move. However, if there is even
more text than expected, that extra text will not display.

 

[Guest]

Fred,

Thanks for the response. Yes, I see that MS Access is only acting logicially.

The report is a Sales Invoice and the field I want to extend is the Delivery
Address field, which sometimes stretches over multiple rows. Just below the
Delivery Address field is a State/Zip/Country field, and below that, nothing
for about 1 inch.
I was hoping that Access would "see" the gap ... as dumb as that sounds.

Anyway, the previous suggestion of adding a new section has solved it for
me. Setting the entire section to CanGrow ensures that no text is lost.

Rael