Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jun 2001
    Location
    California
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Shading in Reports (Access 97)

    I'm generating a report of all employees and their extensions for our receptionists to use. The report is in 2 columns. They've requested that every other line be shaded, but I can't seem to figure out how to do it. Any help out there?

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

    Re: Shading in Reports (Access 97)

    Look at <post#=120973>post 120973</post#> for this solution.
    However, I would use vbYellow rather than vbLightGrey, as I have found it gives a better shading on laser printers.
    HTH
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Shading in Reports (Access 97)

    The method suggested in that post is the standard approach to creating a "graybar" report, but I too have found that a light yellow gives superior results on a laser printer. The light gray will work on a color printer but is too dark on a standard laser printer.
    Charlotte

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Shading in Reports (Access 97)

    Pick up the thread that begins with post number 86413. Within that thread, Charlotte refers to a sample file available from Microsoft that you may find useful.

    You don't mention the printer you're using. FWIW, expect disappointment if you're using a late-model Hewlett-Packard inkjet printer. We use HP 970 and 990 printers, which WILL NOT print the gray-bar reports, even though the formatting displays on-screen. (Our HP laser printers print gray-bars just fine, thank you, but we can't use them for duplex printing. We chose duplex printing over the alternate-line shading.) There are more details in the post I mentioned above, but suffice it to say the only work-around is to install a generic printer driver--which does not support duplex printing!

Posting Permissions

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