report height size


L

LP

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
 
Ad

Advertisements

L

LP

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
 
A

Axess08

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
 
J

John Spencer

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
 
L

LP

Many thanks your help. Problem solved
LP

John Spencer said:
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
 
D

Daniel Churu

That helped me also was struggling there for a minute, thanks




L wrote:

Re: report height size
22-Oct-08

Many thanks your help. Problem solve
L

:

Previous Posts In This Thread:

report height size
h
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
Regard
LP

RE: report height size
Try file/page setup/page and change paper size

:

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.873c
regard

:

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

Cheer

:

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 Spence
Access MVP 2002-2005, 2007-200
The Hilltop Institut
University of Maryland Baltimore Count

LP wrote:

Re: report height size
Many thanks your help. Problem solve
L

:


Submitted via EggHeadCafe - Software Developer Portal of Choice
VB.NET Single Sign-On with DIGEST, BASIC, LDAP
http://www.eggheadcafe.com/tutorials/aspnet/ecafb734-d9da-4bc4-b8b4-f362ec5d0af4/vbnet-single-signon-wit.aspx
 
Ad

Advertisements

Joined
Feb 12, 2019
Messages
1
Reaction score
0
Hello Sir.

I have made report in msaccess but I need to increase the width size more than 55.873cm could you please advise how to increase.

I am waiting for your kind feedback please.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Page Height 0
Reports - Row Heights 2
Report Row Height 1
Column height on reports 1
Maximum Height of a Report 0
Control height on a report 2
height of subform on report 0
sub report height 2

Top