report height size

Discussion in 'Microsoft Access Reports' started by LP, Oct 21, 2008.

  1. LP

    LP Guest

    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
     
    LP, Oct 21, 2008
    #1
    1. Advertisements

  2. LP

    Golfinray Guest

    Try file/page setup/page and change paper size.
     
    Golfinray, Oct 21, 2008
    #2
    1. Advertisements

  3. LP

    LP Guest

    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
     
    LP, Oct 21, 2008
    #3
  4. LP

    Axess08 Guest

    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
     
    Axess08, Oct 21, 2008
    #4
  5. LP

    John Spencer Guest

    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
     
    John Spencer, Oct 21, 2008
    #5
  6. LP

    LP Guest

    Many thanks your help. Problem solved
    LP

     
    LP, Oct 22, 2008
    #6
  7. LP

    Daniel Churu Guest

    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/tutorial...8b4-f362ec5d0af4/vbnet-single-signon-wit.aspx
     
    Daniel Churu, Dec 27, 2009
    #7
  8. LP

    Salman jan

    Joined:
    Tuesday
    Likes Received:
    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.
     
    Salman jan, Feb 12, 2019 at 5:03 AM
    #8
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.