Results 1 to 10 of 10
  1. #1
    a14guguliye is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    6

    Post Report Heading Overflow

    Dear Team,
    i have created a report type in access and the thing is that sometimes, when the second page is needed, the half of the heading of the report passes to the second page. Could u please advise the reason?


    regards,
    Attached Thumbnails Attached Thumbnails first_page.PNG   second_page.PNG  

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Looks like the grey rectangle is wider than the page width. Change to design view and reduce the width
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    a14guguliye is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    6
    Dear Sir,
    it is actually report header and i dont see a width parameter in the property list.
    I can only see
    visible yes
    height
    back color
    auto height
    can grow
    can shrink
    display when
    keep together
    force new page
    new row or col

  4. #4
    a14guguliye is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    6
    I think it has something to do with the report properties, where i see that it goes to right direction a lot. Could u please help me to solve it?

  5. #5
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    In design view, you need to look in the report properties, not the header properties. Or simply grab the right side of the report (hover and mousedown) and drag left. The report can be as narrow as the right edge of the rightmost control, so you may need to move or resize one or more of these to get back to the required width

  6. #6
    a14guguliye is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    6
    Ajax,
    I have done what u said. Unfortunately, due to some unknown reasons, it doesnt move
    regards,

  7. #7
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    due to some unknown reasons, it doesnt move
    most likely

    The report can be as narrow as the right edge of the rightmost control, so you may need to move or resize one or more of these to get back to the required width

  8. #8
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Or possibly you are using layout guides. If so that will limit your flexibility to 'tame' your report
    Open in design view & see if you have a small broken line around a group of controls. If so, try deleting those (using a copy of your report).
    Then you will be able to move / shrink controls as you wish
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  9. #9
    a14guguliye is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    6
    Quote Originally Posted by isladogs View Post
    or possibly you are using layout guides. If so that will limit your flexibility to 'tame' your report
    open in design view & see if you have a small broken line around a group of controls. If so, try deleting those (using a copy of your report).
    Then you will be able to move / shrink controls as you wish

    thank u sir

  10. #10
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Yore welcome.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Group heading in report
    By hatsufi in forum Reports
    Replies: 9
    Last Post: 02-01-2018, 02:56 PM
  2. Replies: 3
    Last Post: 11-02-2017, 10:37 AM
  3. Replies: 1
    Last Post: 04-05-2013, 01:58 PM
  4. Replies: 4
    Last Post: 09-25-2012, 02:54 PM
  5. OVERFLOW error in both Query and Report
    By LanieB in forum Access
    Replies: 9
    Last Post: 11-11-2011, 08:54 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums