Gan/Grow Shrink in page header - is it fixed in Access 2007?

[Benton_in_Lexington]

This has been a major problem for me for years, as I have a large amount of
data in the page header on some occassions but not all. The blank space
drives me crazy! I have tried the quick fixes as suggested, but when the
report detail is in columns, I can't fake a page header with a group header
because it forces it into columns as well. Have they fixed this yet. I
would think by now, they would have added the can/shrink grow propety to the
page header, or at least have come up with some code to do so. Any
suggestions?

 

[Marshall Barton]

This has been a major problem for me for years, as I have a large amount of
data in the page header on some occassions but not all. The blank space
drives me crazy! I have tried the quick fixes as suggested, but when the
report detail is in columns, I can't fake a page header with a group header
because it forces it into columns as well. Have they fixed this yet. I
would think by now, they would have added the can/shrink grow propety to the
page header, or at least have come up with some code to do so.

The Height of the page header can be changed using code, but
some things can be messed up if you do it on the fly. Best
to do it in the report's Open event or at least sometime on
the previous page.

I might(?) be able to provide more detailed ideas if you
will explain more about what you are putting in the page
header.

 

[Marshall Barton]

This does not sound the slightest bit like the OP's problem.

It does sound like you have the ***group*** KeepTogether
property set to Whole Group. Try setting it to either None
or With First Detail.

 

[Benton_in_Lexington]

I can email a copy of the design view of the report, but basically it
contains the parameters of what follows in the report details. If the
parameter is not picked, it is null and doesn't appear in the header. See
the folllowing sample of some of the text boxes is in the page header. Any
suggestions would be a great help.

=Trim(IIf(Not IsNull(Forms!menureport2!rosIDEntity),"ASSOCIATION:"))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosIDEntity),Format$(Forms!menureport2!rosIDEntity.Column(1),">")))
=Trim(IIf(Not IsNull(Forms!menureport2!rosIDConference),"CONFERENCE:"))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosIDConference),Format$(Forms!menureport2!rosIDConference.Column(0),">")))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosIDEntity),Format$(Forms!menureport2!rosIDEntity.Column(1),">")))
=Trim(IIf(Not IsNull(Forms!menureport2!rosEntityMembership),"MEMBERSHIP
LEVEL: "))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosEntityMembership),Format$(Forms!menureport2!rosEntityMembership.Column(0),">")))
=Trim(IIf(Not IsNull(Forms!menureport2!rosIDCorporation),"COMPANY/ORG:"))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosIDCorporation),Format$(Forms!menureport2!rosIDCorporation.Column(0),">")))
=Trim(IIf(Not IsNull(Forms!menureport2!rosAttendence),"ATTENDENCE LEVEL:"))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosAttendence),Format$(Forms!menureport2!rosAttendence.Column(0),">")))

There are about 9 more lines of similar text boxes in the page header. If
they are null in a group header, the group header shrinks. This is okay if
the detail isn't in columns, because I can use the group header work around.
When columns are used it cuts off the group header a part of the column, so
it doesn't work. I need the header to go across the whole page whether the
detail is in columns or not. I could email a copy of the total design view
and what the report looks like if anyone thinks they have a possible work
around.

 

[Marshall Barton]

I think you are barking up the wrong tree because Access
does not do that kind of thing on its own. Somewhere you
have a property set to cause the effect you don't want.

Just guessing again, but doublecheck the make group header
and footer sections' ForceNewPage property make sure are set
to None. It's also conceivable that you have a page break
control at/near the top of the group header or bottom of the
group footer.

 

[Marshall Barton]

The group header is not "chopped off", it is supposed to be
confined to the column width. Actually this is required
because there can be multiple groups of details in each
column.

You could use a bunch of code in the report's Open event to
make the unwanted text boxes invisible and moving them up
before setting the Height of the page header.

OTOH, I think it would be a lot easier to use a subreport
with the columns so you can use the group header approach in
the main report.

 

[Benton_in_Lexington]

Thanks! I'll give the second suggestion a try and see if I can make it work.
You are correct that I have multiple groups of detail in each column. Iv'e
tried a subreport before, but it made the report detail look a little odd. I
really didn't mess with it that much though. I'll give it a try again.

The group header is not "chopped off", it is supposed to be
confined to the column width. Actually this is required
because there can be multiple groups of details in each
column.

You could use a bunch of code in the report's Open event to
make the unwanted text boxes invisible and moving them up
before setting the Height of the page header.

OTOH, I think it would be a lot easier to use a subreport
with the columns so you can use the group header approach in
the main report.
--
Marsh
MVP [MS Access]

I can email a copy of the design view of the report, but basically it
contains the parameters of what follows in the report details. If the
parameter is not picked, it is null and doesn't appear in the header. See
the folllowing sample of some of the text boxes is in the page header. Any
suggestions would be a great help.

=Trim(IIf(Not IsNull(Forms!menureport2!rosIDEntity),"ASSOCIATION:"))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosIDEntity),Format$(Forms!menureport2!rosIDEntity.Column(1),">")))
=Trim(IIf(Not IsNull(Forms!menureport2!rosIDConference),"CONFERENCE:"))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosIDConference),Format$(Forms!menureport2!rosIDConference.Column(0),">")))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosIDEntity),Format$(Forms!menureport2!rosIDEntity.Column(1),">")))
=Trim(IIf(Not IsNull(Forms!menureport2!rosEntityMembership),"MEMBERSHIP
LEVEL: "))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosEntityMembership),Format$(Forms!menureport2!rosEntityMembership.Column(0),">")))
=Trim(IIf(Not IsNull(Forms!menureport2!rosIDCorporation),"COMPANY/ORG:"))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosIDCorporation),Format$(Forms!menureport2!rosIDCorporation.Column(0),">")))
=Trim(IIf(Not IsNull(Forms!menureport2!rosAttendence),"ATTENDENCE LEVEL:"))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosAttendence),Format$(Forms!menureport2!rosAttendence.Column(0),">")))

There are about 9 more lines of similar text boxes in the page header. If
they are null in a group header, the group header shrinks. This is okay if
the detail isn't in columns, because I can use the group header work around.
When columns are used it cuts off the group header a part of the column, so
it doesn't work. I need the header to go across the whole page whether the
detail is in columns or not. I could email a copy of the total design view
and what the report looks like if anyone thinks they have a possible work
around.