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
|
|||
|
|||
report height size
hi
I have a report full of labels and text boxes. I need to increase its height size. when I go to the bottom and try to pull down the size of the details section I get the message "the control or subform control is too large for this location. reduce the size of the control or subform control, or enter a positive number". the height size is 55.873cm. Is there a way to increase it? Regards LP |
#2
|
|||
|
|||
report height size
Try file/page setup/page and change paper size.
"LP" wrote: hi I have a report full of labels and text boxes. I need to increase its height size. when I go to the bottom and try to pull down the size of the details section I get the message "the control or subform control is too large for this location. reduce the size of the control or subform control, or enter a positive number". the height size is 55.873cm. Is there a way to increase it? Regards LP |
#3
|
|||
|
|||
report height size
Thanks for your reply.
i am not too clear about the 55.873cm paper height. the paper size set at the moment is A4 landscape, which is 21cm. my printer does not allow for bigger than A4. This report prints over 4 pages anyway. what i want to know is how to increase the details section beyond 55.873cm regards "Golfinray" wrote: Try file/page setup/page and change paper size. "LP" wrote: hi I have a report full of labels and text boxes. I need to increase its height size. when I go to the bottom and try to pull down the size of the details section I get the message "the control or subform control is too large for this location. reduce the size of the control or subform control, or enter a positive number". the height size is 55.873cm. Is there a way to increase it? Regards LP |
#4
|
|||
|
|||
report height size
Access Reports by default have a limited page size of 22 in total (including
headers, footers, details sections). If your control is bigger than that, it will not print all of it depsite the fact that Access can clearly print many pages, it does not (height wise) print more than 22 in worth. Can you break up your control/subreport into miniature versions and print it width wise? (Although if you do it this way, the page numbering will be off if located in the header/footer section). I hope this helps! Cheers "LP" wrote: Thanks for your reply. i am not too clear about the 55.873cm paper height. the paper size set at the moment is A4 landscape, which is 21cm. my printer does not allow for bigger than A4. This report prints over 4 pages anyway. what i want to know is how to increase the details section beyond 55.873cm regards "Golfinray" wrote: Try file/page setup/page and change paper size. "LP" wrote: hi I have a report full of labels and text boxes. I need to increase its height size. when I go to the bottom and try to pull down the size of the details section I get the message "the control or subform control is too large for this location. reduce the size of the control or subform control, or enter a positive number". the height size is 55.873cm. Is there a way to increase it? Regards LP |
#5
|
|||
|
|||
report height size
The maximum height of a report SECTION is 22 inches or 55.8 centimeters. The
maximum height of a report (all sections) is 200 inches or ??? centimeters SO, you can add a group headers and footers and they can each be 22 inches (55.8 cm). Add the group header/footer based on a unique value (such as a primary key) so it creates a header and/or footer for each record in the detail section. John Spencer Access MVP 2002-2005, 2007-2008 The Hilltop Institute University of Maryland Baltimore County LP wrote: hi I have a report full of labels and text boxes. I need to increase its height size. when I go to the bottom and try to pull down the size of the details section I get the message "the control or subform control is too large for this location. reduce the size of the control or subform control, or enter a positive number". the height size is 55.873cm. Is there a way to increase it? Regards LP |
#6
|
|||
|
|||
report height size
Many thanks your help. Problem solved
LP "John Spencer" wrote: The maximum height of a report SECTION is 22 inches or 55.8 centimeters. The maximum height of a report (all sections) is 200 inches or ??? centimeters SO, you can add a group headers and footers and they can each be 22 inches (55.8 cm). Add the group header/footer based on a unique value (such as a primary key) so it creates a header and/or footer for each record in the detail section. John Spencer Access MVP 2002-2005, 2007-2008 The Hilltop Institute University of Maryland Baltimore County LP wrote: hi I have a report full of labels and text boxes. I need to increase its height size. when I go to the bottom and try to pull down the size of the details section I get the message "the control or subform control is too large for this location. reduce the size of the control or subform control, or enter a positive number". the height size is 55.873cm. Is there a way to increase it? Regards LP |
#7
|
|||
|
|||
Report height
That helped me also was struggling there for a minute, thanks
L wrote: report height size 22-Oct-08 Many thanks your help. Problem solved LP "John Spencer" wrote: Previous Posts In This Thread: On Tuesday, October 21, 2008 9:08 AM L wrote: report height size hi I have a report full of labels and text boxes. I need to increase its height size. when I go to the bottom and try to pull down the size of the details section I get the message "the control or subform control is too large for this location. reduce the size of the control or subform control, or enter a positive number". the height size is 55.873cm. Is there a way to increase it? Regards LP On Tuesday, October 21, 2008 9:18 AM Golfinra wrote: report height size Try file/page setup/page and change paper size. "LP" wrote: On Tuesday, October 21, 2008 9:28 AM L wrote: Thanks for your reply.i am not too clear about the 55.873cm paper height. Thanks for your reply. i am not too clear about the 55.873cm paper height. the paper size set at the moment is A4 landscape, which is 21cm. my printer does not allow for bigger than A4. This report prints over 4 pages anyway. what i want to know is how to increase the details section beyond 55.873cm regards "Golfinray" wrote: On Tuesday, October 21, 2008 10:29 AM Axess0 wrote: Access Reports by default have a limited page size of 22 in total (including Access Reports by default have a limited page size of 22 in total (including headers, footers, details sections). If your control is bigger than that, it will not print all of it depsite the fact that Access can clearly print many pages, it does not (height wise) print more than 22 in worth. Can you break up your control/subreport into miniature versions and print it width wise? (Although if you do it this way, the page numbering will be off if located in the header/footer section). I hope this helps! Cheers "LP" wrote: On Tuesday, October 21, 2008 11:51 AM John Spencer wrote: The maximum height of a report SECTION is 22 inches or 55.8 centimeters. The maximum height of a report SECTION is 22 inches or 55.8 centimeters. The maximum height of a report (all sections) is 200 inches or ??? centimeters SO, you can add a group headers and footers and they can each be 22 inches (55.8 cm). Add the group header/footer based on a unique value (such as a primary key) so it creates a header and/or footer for each record in the detail section. John Spencer Access MVP 2002-2005, 2007-2008 The Hilltop Institute University of Maryland Baltimore County LP wrote: On Wednesday, October 22, 2008 4:20 AM L wrote: report height size Many thanks your help. Problem solved LP "John Spencer" wrote: Submitted via EggHeadCafe - Software Developer Portal of Choice VB.NET Single Sign-On with DIGEST, BASIC, LDAP http://www.eggheadcafe.com/tutorials...ignon-wit.aspx |
Thread Tools | |
Display Modes | |
|
|