@raellucid: "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"
    @AllenBrowne: "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
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - <url>
Reply to group, rather than emoore@example.org.
news:<email_address>
<quote>"
    @fgutkind: "<quote>
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.
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail"
    @raellucid: "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
<quote>"
{'source': 'USENET', 'other_information': '{"reply_count": 3, "forum_name": "microsoft.public.access.reports.20140630.mbox"}', 'file': 'data/output/usenet-microsoft.public.parquet'}