Feb 14 2007, 12:21 PM
I have a subform that returns a bunch of records. Each of the records returned has a LANE_ID, so in this example, there are 10 records returned, 5 with LANE_ID = 11111and 5 with LANE_ID = 22222. Is it possible to alternate the backgrond color for each of these groupings?
I have found examples of how to change the color of alternate rows, but I can't find anything that would tell me if what I want to do is possible.
Feb 14 2007, 02:11 PM
This can probably be done, but it will not be easy. You see how to do the alternate rows so maybe you can adapt that approach. I have not seen done what you want to do so I have no suggestions on how to solve it....
Feb 15 2007, 05:28 AM
Sounds like what you are trying to do is very similar to a little conundrum I had the other day.
My solution is at the bottom if the follwoing thread... Conditional formatting thread
Hope this helps
Feb 15 2007, 05:30 AM
You can use conditional formatting to set the background of all records with LANE_ID = 22222 to a particular color.
If you only want 2 colors then you just need a single conditional format statement, but you first have to find the list of LANE_IDs which need their colors changing.
The alternate row coloring trick (using bookmarks) will not help you
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here