Results 1 to 2 of 2
  1. 02-02-2010, 05:24 PM #1
    vCallNSPF
    vCallNSPF is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Posts
    49

    Preventing entries from going over 2 pages in a report

    ive got a database with a final report showing EVERYTHING is the database. for each table, each entries representation in a report goes for on average a 3rd of a page. every now and then they will overlap over 2 pages. i want it so that if it is going to over lap it just "page breaks" automatically to the next page.
    Reply With Quote Reply With Quote
  2. 02-03-2010, 08:27 AM #2
    llkhoutx
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Access won't do this easily. One way would be to count lines on the report's Detail Section OnFormat event and changing the visibility of a PageBreak control when appropriate for a new page. A hidden PageBreak control will not force a page break, a visible one will.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Balnk Pages in Report
    By jbarrum in forum Access
    Replies: 3
    Last Post: 01-28-2010, 01:58 PM
  2. Preventing multiple checkboxes
    By emerywang in forum Forms
    Replies: 2
    Last Post: 01-26-2010, 01:43 PM
  3. Blank pages between report pages
    By jonsuns7 in forum Reports
    Replies: 2
    Last Post: 10-01-2009, 05:06 AM
  4. pages
    By hokie in forum Reports
    Replies: 0
    Last Post: 07-16-2009, 10:08 AM
  5. Data preventing Referential Integrity
    By RubberStamp in forum Access
    Replies: 0
    Last Post: 12-14-2008, 05:43 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums