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

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?

Benton_in_Lexington wrote:

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.

--
Marsh
MVP [MS Access]

My problem is very similar; can you help me. My report lists car dealers and
the makes and models they carry. The dealer is determined by the current
record in FrmDealer and demographics are displayed in the main report. The
detail section lists each make and the models are listed in a subreport
under the model. My problem is at the bottom of the page above the footer.
Access always keeps the make and all models together no matter how I set
Keep Together. When a make and ALL its models won't fit at the bottom of a
page, the make and all its models are printed at the top of the next page.
This causes a white space above the footer. Of note, the model subreport is
a two column report. Is it possible to break a page between the make record
and the model subreport? And also, is it possible to break a page in the
middle of the model subreport so some models are printed at the bottom of a
page and the remaining models of the same make are printed at the top of the
next page?

Thanks!


"Marshall Barton" wrote in message
...
Benton_in_Lexington wrote:

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.

--
Marsh
MVP [MS Access]

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.
--
Marsh
MVP [MS Access]


Deryl wrote:
My problem is very similar; can you help me. My report lists car dealers and
the makes and models they carry. The dealer is determined by the current
record in FrmDealer and demographics are displayed in the main report. The
detail section lists each make and the models are listed in a subreport
under the model. My problem is at the bottom of the page above the footer.
Access always keeps the make and all models together no matter how I set
Keep Together. When a make and ALL its models won't fit at the bottom of a
page, the make and all its models are printed at the top of the next page.
This causes a white space above the footer. Of note, the model subreport is
a two column report. Is it possible to break a page between the make record
and the model subreport? And also, is it possible to break a page in the
middle of the model subreport so some models are printed at the bottom of a
page and the remaining models of the same make are printed at the top of the
next page?


"Marshall Barton" wrote
Benton_in_Lexington wrote:

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.

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$(Form s!menureport2!rosIDEntity.Column(1),"")))
=Trim(IIf(Not IsNull(Forms!menureport2!rosIDConference),"CONFERE NCE:"))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosIDConference),Format$( Forms!menureport2!rosIDConference.Column(0),"")))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosIDEntity),Format$(Form s!menureport2!rosIDEntity.Column(1),"")))
=Trim(IIf(Not IsNull(Forms!menureport2!rosEntityMembership),"MEM BERSHIP
LEVEL: "))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosEntityMembership),Form at$(Forms!menureport2!rosEntityMembership.Column(0 ),"")))
=Trim(IIf(Not IsNull(Forms!menureport2!rosIDCorporation),"COMPAN Y/ORG:"))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosIDCorporation),Format$ (Forms!menureport2!rosIDCorporation.Column(0),"") ))
=Trim(IIf(Not IsNull(Forms!menureport2!rosAttendence),"ATTENDENC E LEVEL:"))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosAttendence),Format$(Fo rms!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.


"Benton_in_Lexington" wrote:

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?

BTW ..... Access2007

Group Keep Together is set at 'do not keep group together on one page'.

Do you know ...
Is it possible to break a page between the make record and the model
subreport?

Of note - the linkmaster and linkchild properties are set to ModelID.

Thanks!




"Marshall Barton" wrote in message
...
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.
--
Marsh
MVP [MS Access]


Deryl wrote:
My problem is very similar; can you help me. My report lists car dealers
and
the makes and models they carry. The dealer is determined by the current
record in FrmDealer and demographics are displayed in the main report. The
detail section lists each make and the models are listed in a subreport
under the model. My problem is at the bottom of the page above the footer.
Access always keeps the make and all models together no matter how I set
Keep Together. When a make and ALL its models won't fit at the bottom of a
page, the make and all its models are printed at the top of the next page.
This causes a white space above the footer. Of note, the model subreport
is
a two column report. Is it possible to break a page between the make
record
and the model subreport? And also, is it possible to break a page in the
middle of the model subreport so some models are printed at the bottom of
a
page and the remaining models of the same make are printed at the top of
the
next page?


"Marshall Barton" wrote
Benton_in_Lexington wrote:

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.

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.
--
Marsh
MVP [MS Access]


Deryl wrote:
BTW ..... Access2007
Group Keep Together is set at 'do not keep group together on one page'.

Do you know ...
Is it possible to break a page between the make record and the model
subreport?

Of note - the linkmaster and linkchild properties are set to ModelID.


"Marshall Barton" wrote
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.


Deryl wrote:
My problem is very similar; can you help me. My report lists car dealers
and
the makes and models they carry. The dealer is determined by the current
record in FrmDealer and demographics are displayed in the main report. The
detail section lists each make and the models are listed in a subreport
under the model. My problem is at the bottom of the page above the footer.
Access always keeps the make and all models together no matter how I set
Keep Together. When a make and ALL its models won't fit at the bottom of a
page, the make and all its models are printed at the top of the next page.
This causes a white space above the footer. Of note, the model subreport
is a two column report. Is it possible to break a page between the make
record
and the model subreport? And also, is it possible to break a page in the
middle of the model subreport so some models are printed at the bottom of
a page and the remaining models of the same make are printed at the top of
the next page?


"Marshall Barton" wrote
Benton_in_Lexington wrote:

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.

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]


Benton_in_Lexington wrote:
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$(For ms!menureport2!rosIDEntity.Column(1),"")))
=Trim(IIf(Not IsNull(Forms!menureport2!rosIDConference),"CONFERE NCE:"))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosIDConference),Format$ (Forms!menureport2!rosIDConference.Column(0),"")) )
=Trim(IIf(Not
IsNull(Forms!menureport2!rosIDEntity),Format$(For ms!menureport2!rosIDEntity.Column(1),"")))
=Trim(IIf(Not IsNull(Forms!menureport2!rosEntityMembership),"MEM BERSHIP
LEVEL: "))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosEntityMembership),For mat$(Forms!menureport2!rosEntityMembership.Column( 0),"")))
=Trim(IIf(Not IsNull(Forms!menureport2!rosIDCorporation),"COMPAN Y/ORG:"))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosIDCorporation),Format $(Forms!menureport2!rosIDCorporation.Column(0),"" )))
=Trim(IIf(Not IsNull(Forms!menureport2!rosAttendence),"ATTENDENC E LEVEL:"))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosAttendence),Format$(F orms!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.


"Benton_in_Lexington" wrote:
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?

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.

"Marshall Barton" wrote:

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]


Benton_in_Lexington wrote:
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$(For ms!menureport2!rosIDEntity.Column(1),"")))
=Trim(IIf(Not IsNull(Forms!menureport2!rosIDConference),"CONFERE NCE:"))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosIDConference),Format$ (Forms!menureport2!rosIDConference.Column(0),"")) )
=Trim(IIf(Not
IsNull(Forms!menureport2!rosIDEntity),Format$(For ms!menureport2!rosIDEntity.Column(1),"")))
=Trim(IIf(Not IsNull(Forms!menureport2!rosEntityMembership),"MEM BERSHIP
LEVEL: "))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosEntityMembership),For mat$(Forms!menureport2!rosEntityMembership.Column( 0),"")))
=Trim(IIf(Not IsNull(Forms!menureport2!rosIDCorporation),"COMPAN Y/ORG:"))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosIDCorporation),Format $(Forms!menureport2!rosIDCorporation.Column(0),"" )))
=Trim(IIf(Not IsNull(Forms!menureport2!rosAttendence),"ATTENDENC E LEVEL:"))
=Trim(IIf(Not
IsNull(Forms!menureport2!rosAttendence),Format$(F orms!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.


"Benton_in_Lexington" wrote:
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?