Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Toledo, Ohio, USA
    Thanked 0 Times in 0 Posts

    Conditional Page Breaks

    I have a report for which I want to force a page break when the contents of a specific field in the detail portion of the report changes. I've searched MSDN and the Access97 help and am struggling to do this. I know I need to put a page break control somewhere and need to set/reset it in the header/detail portions via event procedures, but how do I detect hat the contents of the control that triggers the page break has changed? Is there a statement similar to the following that would accomplish this?

    If Me![control].changed then
    pagebreak.visible = true
    end if

    I know that .changed is not valid snytax. Can anyone explain how I should do this? Thanks in advance.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: Conditional Page Breaks

    You could easily set a grouping on that field and include a header for it with zero height and no controls. If you set the Force New Page property of that group to Before Section, it will automatically force a page break when the value of the field that defines the group changes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts