Results 1 to 2 of 2
  1. 08-16-2012, 07:37 AM #1
    EddieN1
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    316

    Dynamic Page Breaks in Reports using VBA


    Is there a way I can use VBA to interrogate a condition in the Current record and based on that force a page break? Thanks, Eddie
    Reply With Quote Reply With Quote
  2. 08-16-2012, 11:59 AM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Sure, this type of thing should work, in one of the format events:

    Code:
      If YourConditionHere Then
    Me.PageBreak67.Visible = True
  Else
    Me.PageBreak67.Visible = False
  End If
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Forced page breaks - I know really something quite simple
    By kw@officeadminsolutions in forum Reports
    Replies: 3
    Last Post: 05-16-2011, 12:17 AM
  2. Page Breaks and the Report Footer
    By dssrun in forum Reports
    Replies: 4
    Last Post: 05-03-2011, 03:23 PM
  3. Page breaks
    By berni3883 in forum Reports
    Replies: 0
    Last Post: 03-31-2011, 01:25 PM
  4. Figure Numbers incrementing over Page Breaks
    By jezzamax in forum Reports
    Replies: 3
    Last Post: 12-19-2010, 08:05 PM
  5. Page Breaks. Is there a way to do it?
    By newtoAccess in forum Reports
    Replies: 8
    Last Post: 11-30-2010, 01:02 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums