Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Melbourne, Victoria, Australia
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form feeds on Odd page numbers (Access 2000 SR-1)

    I have a report which I would like to be able to force a form feed after odd numbered pages.
    What I'd like to see is Page1, Blank page, Page 2, Page 3, Blank Page etc.
    I have tried to implement the logic in the On Format and On Print properties
    within the Page Footer by this code. Basically if remainder is one, send a FF.

    If ([Page] Mod 2) = 1 Then
    Print Chr(12)
    End If

    Obviously not working, so any advice would be appreciated.
    Regards
    Michael

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Form feeds on Odd page numbers (Access 2000 SR-1)

    Do you actually want to print a blank page or just number the pages 1,3,5,....,etc.?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Melbourne, Victoria, Australia
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form feeds on Odd page numbers (Access 2000 SR-1)

    Hi Mark,
    Just a blank page and thanks for your web page address.
    Regards
    Michael

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Form feeds on Odd page numbers (Access 2000 SR-1)

    Well, to actually "print" a blank page, I'd place a page break control in the Page Header section, and in the section's Format event you will need code to toggle the visibility of the break control depending on whether it is an odd or even page, something like this (assumes the page break control is named pgBrk):
    pgBrk.visible = (me.page mod 2 = 0)

    Should work.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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