Results 1 to 3 of 3
  1. #1
    Talayoe is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2012
    Posts
    14

    Page Breaks

    Hello all, I have a report that I need to print every morning. This report was setup to print with (3) different headers. Active Orders, Orders on Hold and Orders Outside. These print fine, but they print one after another which causes me some ... grief. What I would like to do is have the Orders on hold and Orders outside forced to a new page, since they never have taken entire page and I often end up with three or four lines on the same page as the Active Orders...which looks odd. "=IIf([P]="Y","Jobs on HOLD",IIf([P]="Z","Outside",IIf([P]="W","Active Orders")))" is what my current setup looks like under the P Header Section. Any help would be super!

  2. #2
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    It's been a while since I've designed a report but I recall that I would often create multiple subreports and then insert them into a main type report where the main report only contained the unique identity record number for linking all the subreports (so the "where" clause could also be used when opening the report). I'd uncheck the 'allow grow' and 'allow shrink' properties on the subreport and size each to fit in specific places or take up an entire page. I don't know if this helps for your situation but it made things easier for showing data in specific places on a report.

  3. #3
    Talayoe is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2012
    Posts
    14
    Hello. I gave this a good bash and couldn't get it to do quite what I was wanting (seemed to always land me with a complete extra page of nothingness). I may be able to do this with a little bit of coding... more specifically if there was a way that I can add a page break 'command line' (not just pushing the 'insert page break') into the code for the particular area where I want the break, maybe then I can get it done? Maybe I am just fighting a battle that needs not be fought? Off handedly, why is it that on this forum you cannot create paragraphs. It looks quite messy to have long sentences because of what seems to be an 'enter lock' of sorts... strikes me as strange.

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

Similar Threads

  1. Dynamic Page Breaks in Reports using VBA
    By EddieN1 in forum Reports
    Replies: 1
    Last Post: 08-16-2012, 11:59 AM
  2. 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
  3. Page Breaks and the Report Footer
    By dssrun in forum Reports
    Replies: 4
    Last Post: 05-03-2011, 03:23 PM
  4. Page breaks
    By berni3883 in forum Reports
    Replies: 0
    Last Post: 03-31-2011, 01:25 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
  •  
Other Forums: Microsoft Office Forums