If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Gan/Grow Shrink in page header - is it fixed in Access 2007?
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] |
#3
|
|||
|
|||
Gan/Grow Shrink in page header - is it fixed in Access 2007?
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] |
#4
|
|||
|
|||
Gan/Grow Shrink in page header - is it fixed in Access 2007?
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. |
#5
|
|||
|
|||
Gan/Grow Shrink in page header - is it fixed in Access 2007?
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? |
#6
|
|||
|
|||
Gan/Grow Shrink in page header - is it fixed in Access 2007?
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. |
#7
|
|||
|
|||
Gan/Grow Shrink in page header - is it fixed in Access 2007?
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. |
#8
|
|||
|
|||
Gan/Grow Shrink in page header - is it fixed in Access 2007?
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? |
#9
|
|||
|
|||
Gan/Grow Shrink in page header - is it fixed in Access 2007?
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? |
Thread Tools | |
Display Modes | |
|
|