INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

How To

Alternate Gray Lines on Report by Garridon
Posted: 1 Nov 02

You may want to make a report easier to read by having alternating gray lines.  To do this, go to your report's properties and add an event procedure to your On Format of your detail section.  The constant can be changed to whatever color you want (a quick way to get the number is to choose a background color in one of your forms, and then copy the number and paste it in code).

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

    Const vbLightGrey = 14540253

    If Me.CurrentRecord Mod 2 = 0 Then

      Me.Section(acDetail).BackColor = vbLightGrey

   Else

      Me.Section(acDetail).BackColor = vbWhite

   End If

 End Sub


Back to Microsoft: Access Reports FAQ Index
Back to Microsoft: Access Reports Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close