Page 1 of 2 12 LastLast
Results 1 to 15 of 30
  1. #1
    Dropout is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2019
    Location
    Ontario
    Posts
    19

    Page break in a report

    Good morning.



    Just working on report and I can't figure out how to add a page break. I tried inserting one but it doesn't work. Maybe it's the report design or something.

    In the report I'd like the different bins to be on separate pages.

    Thanks.
    Attached Thumbnails Attached Thumbnails Screenshot 2020-02-21 11.24.34.png   Screenshot 2020-02-21 11.21.14.png  

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    add a visible BIN FOOTER,
    then drop a page break inside this band.

  3. #3
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Or use the ForceNewPage property:https://docs.microsoft.com/en-us/off...n.forcenewpage

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  4. #4
    Dropout is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2019
    Location
    Ontario
    Posts
    19
    Thanks for the feedback.

    The footer option seems best for me but I can't figure out how to add it as you suggest. I can add/delete page or report footer but not a bin # footer. What am I missing?

  5. #5
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    On the Design ribbon click the Group And Sort then on the bottom clcik the Bin group and select With Footer.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  6. #6
    Dropout is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2019
    Location
    Ontario
    Posts
    19
    Thanks.

    This is what I have and still not working - I must be missing something...
    Attached Thumbnails Attached Thumbnails Screenshot 2020-02-21 13.47.52.png  

  7. #7
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Remove the page breaks you added into the bin footer and page footer then select (click) the bin footer and in the properties box look for Force New Page and select After. Clean up the sections (no need for any space to show in the bin footer or above the Now textbox in the page footer).

    Cheers,
    Vlad
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  8. #8
    Dropout is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2019
    Location
    Ontario
    Posts
    19
    I think I got all that right, but no change.
    Attached Thumbnails Attached Thumbnails Screenshot 2020-02-21 16.14.42.png  

  9. #9
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Can you upload a small db sample with the report in question a a few "dummy" records? Looks good otherwise, but why the labels on the page header and not in the bin header (under the Bin # group label)?

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  10. #10
    Dropout is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2019
    Location
    Ontario
    Posts
    19
    Here you go.

    The form was created using a wizard so I'm not sure why things are where they are.

    Thanks.
    Attached Files Attached Files

  11. #11
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    I think you're good, you need to look at it in Print Preview mode to see the breaks, you were probably using Layout or Report View.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  12. #12
    CarlettoFed is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Dec 2019
    Posts
    255
    1 - select Bib # Header and in the All tab set the properties:
    Unit Section Print -> No
    Page break -> None
    2 - select Detail and in the All tab set the properties:
    Unit Section Print -> No
    Page break -> None
    3 - select Bin # Footer and in the All tab set the properties:
    Unit Section Print -> No
    Page break -> After section

    now click on Print Preview and not Report view

  13. #13
    Dropout is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2019
    Location
    Ontario
    Posts
    19
    That was it, looking at the wrong view.

    Sorry for the extra hassle.

    Thanks again.

  14. #14
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    No worries, an extra oair of eyes (almost) always helps !
    Cheers,

  15. #15
    Dropout is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2019
    Location
    Ontario
    Posts
    19
    Good morning.

    After using this report for a few weeks I decided to use what I learned and reference a query rather than a table. Now I get a page break after each part number rather than bin number. I've played with it for a week or so and can't figure it out.

    Here is the query and the report and the first page of the print preview. Any and all ideas welcome.
    Attached Thumbnails Attached Thumbnails Screenshot 2020-03-17 11.54.13.png   Screenshot 2020-03-17 11.54.27.png   Screenshot 2020-03-17 11.54.50.png   Screenshot 2020-03-17 12.03.38.png  

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 02-04-2016, 08:13 AM
  2. Replies: 3
    Last Post: 12-22-2015, 03:23 AM
  3. Report with page break appears with a blank page, why?
    By clebergyn in forum Programming
    Replies: 4
    Last Post: 02-24-2014, 12:32 PM
  4. Page Break in Report
    By MarshallSutton in forum Reports
    Replies: 2
    Last Post: 09-23-2011, 05:54 PM
  5. Page break on report inserts empty page between
    By Galadrielle in forum Reports
    Replies: 0
    Last Post: 07-07-2010, 04:18 AM

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