Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Alternating Report background? (AXP 10.2627.2625)

    How do I print a report such that every EVEN line has a light gray background. The idea is to allow easy reading across a landscape format page. It seems that I will have to code the writing of each line myself (?) but i would of course prefer that Access do the work right out of the box.

    In the above, "even" could be variable, so that a report could be printed with every other pair, or every tuple, of lines grayed.

    At the moment, I'm only looking at gray, not color. I've also thought of using precolored paper.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Alternating Report background? (AXP 10.2627.2625)

    I don't know if AXP have this build in but you could use this in the On Format of the Detail Section:
    <pre>Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Const vbLightGrey = 12632256
    If Me.CurrentRecord Mod 2 = 0 Then
    Me.Section(acDetail).BackColor = vbLightGrey
    Else
    Me.Section(acDetail).BackColor = vbWhite
    End If
    End Sub
    </pre>

    Francois

  3. #3
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Alternating Report background? (AXP 10.2627.2625)

    Egg ZACKLY what i wanted!

    Thanks Francois

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Alternating Report background? (AXP 10.2627.2625)

    What I have found is that the Light grey is in fact too dark on the report, I have used vbYellow instead of Light Grey for a much lighter grey effect.
    HTH
    Pat

Posting Permissions

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