Results 1 to 7 of 7
  1. #1
    97rstd is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2011
    Posts
    6

    Alternating colors in a report


    I have an access report with a sub report. I have the subreport set with alternate background color so every other line is shaded. My problem is that on page 3 of my report, the rows don't alternate shading. It is fine on all prior pages and all pages after 3. I'm at a total loss as to what to even look for. Any suggestions?

  2. #2
    mejia.j88 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Nov 2011
    Location
    california
    Posts
    228
    does the sub report show up on all three pages?
    if so, does the coloring alternate?

  3. #3
    97rstd is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2011
    Posts
    6
    Yes my sub report views perfectly fine as far as the data goes. And the colors alternate on pages 1 and 2 and also on 4. I can't for the life of me figure out why page 3 of the subreport is one solid color.

  4. #4
    mejia.j88 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Nov 2011
    Location
    california
    Posts
    228
    is your report always 4 pages?
    would you be able to provide a stripped down version of the project?

  5. #5
    97rstd is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2011
    Posts
    6
    No, in fact it is seldom four pages. Usually it is 1 or 2. I'm definately an access amateur but I looked at all the logical ideas and I'm at a loss as to why it would change all of a sudden but it is consistently on page 3.

  6. #6
    mejia.j88 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Nov 2011
    Location
    california
    Posts
    228
    can you provide the db for a closer look?

  7. #7
    Gainzim is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2014
    Posts
    9
    Hello again, please could you tell me how to alternat shading on line in a report. I know there is an answer somewhere but cat find it.
    Thanks you

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

Similar Threads

  1. Replies: 7
    Last Post: 03-04-2012, 05:08 PM
  2. Replies: 1
    Last Post: 11-02-2011, 03:15 AM
  3. Replies: 30
    Last Post: 03-01-2011, 10:05 AM
  4. Alternating Greenbar report
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-30-2010, 10:05 PM
  5. Replies: 0
    Last Post: 10-24-2008, 11:20 AM

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