Results 1 to 3 of 3
  1. #1
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,523

    SUB-Report does not print all records if there is > 1 page of data.


    Access SUB-Report does not print all records if there is > 1 page.

    It ONLY prints 1 full page of data, no more.
    BUT If I print the subreport by itself, it prints all data.
    but as a subreport, it only prints 1 full page.

    There are NO limitations on the subreport:
    query pulls all records
    visible: yes
    can shrink: yes
    can grow: yes
    display when: always


    Ideas?

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,911
    Links to main report?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,405
    Subreports can be sensitive to the report section they are in.
    Also can differ in print view and print preview, depending on section.

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

Similar Threads

  1. Replies: 1
    Last Post: 11-11-2016, 07:02 PM
  2. Replies: 1
    Last Post: 09-29-2016, 03:12 AM
  3. Replies: 2
    Last Post: 02-06-2013, 09:19 PM
  4. Report print two records per page
    By dwilson in forum Reports
    Replies: 3
    Last Post: 07-21-2012, 10:48 AM
  5. Replies: 3
    Last Post: 08-07-2011, 09:22 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