Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    7

    Unanswered: Reports and forcing page breaks

    Hi

    I have a report in Access 2000. Sometimes one part of the report is at the bottom of the page and I would like to force it onto the next page. Because of the format of the report, the 'force new page' options' aren't useful to me as the section has 3 separate textboxes and labels that I don't want to join together because of formating.

    So I have tried using the report.top property and object.top to force page breaks. But I just can't get it to work.

    This is what I have been up to:

    If me.pagebreak1.top > 8000 then

    me.pagebreak1.visible=true
    else
    me.pagebreak1.visible=false
    end if


    Also, each textbox in the section could go over the page, so I need three separate potential forced breaks.

    Where have I gone wrong?

    Thanks

    Leonard

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Environment:
    Self Taught In ALL Environments.....And It Shows!


Posting Permissions

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