Results 1 to 2 of 2
  1. #1
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168

    New page for each Filtered

    I have a report. List of houses by the Chapter they belong to. and I want each chapters houses to print on it own page.

    I went through a tutorial that covered the "Force New Page" and "New Row Or Col" properties of the form, but I cant seem to get it to break apart for printing the way I want to .

    Page Header
    "OH Colorado List of Houses"



    ChapterName Header
    "Chapter - Chapter Name"

    Detail
    "House Name" "House Address"



    BONUS QUESTION: I would also like to know if it is possible to have it print only what full sections will fit on the page

    So for example all of the list of houses for chapter one, and the list of houses in chapter two, would print on the first page.

    But the list for chapter 3 would not start until page 2. ( even though there would have been room to start it on page one)


    Thanks for everyone's help

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    What if chapter 3 doesn't fit fully on one page?

    There is a KeepTogether property but I've never figured it out.

    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. FIltered Report based on filtered SubForm
    By Misterpokey in forum Programming
    Replies: 1
    Last Post: 03-16-2020, 08:27 AM
  2. Replies: 4
    Last Post: 08-11-2018, 11:22 AM
  3. Filtered Records Wont Stay Filtered
    By ortizimo in forum Access
    Replies: 4
    Last Post: 11-29-2017, 07:08 PM
  4. Replies: 1
    Last Post: 11-11-2016, 07:02 PM
  5. Filtered Report from filtered datasheet form
    By gemadan96 in forum Reports
    Replies: 7
    Last Post: 01-03-2014, 05:12 PM

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