Alternate Row Color

[tgambill]

I have been trying to set my reports such that alternating rows are a different color with no success. I opened the form in design mode and clicked on the details section, then went to the Format tab and in the background section of the ribbon I changed the alternate row color, saved the report and this did not work. I opened the property sheet for the detail section and chose a color in the alternate back color section, saved the report and this did not work either.

Any other suggestions on how I can do this?

 

[plog]

Add a new object to your Detail Section. Change these properties:

Name: rowcolor
Control Source: =1
Visible: No
Running Sum: Over All

Now add a conditional formatting rule to every object using this Expression:

[rowcolor] Mod 2=1

Then select the color you want the row to be. Then add another conditional formatting rule to every object using this Expression:

[rowcolor] Mod 2=0

Then select a different color for the alternating row.

 

[tgambill]

Thank you for responding so quickly. I'm new to this. How do I add a conditional formatting rule to every object?

 

[plog]

Select all the objects, go to the 'Format' tab of the ribbon, click the 'Conditional Formatting' in the Control Formatting section.

 

[tgambill]

Ok, I selected all the object, found the 'Conditional Formatting' button in the Control Formatting section but it is grayed out.

 

[plog]

You might have selected an object that can't be conditionally formatted--a line, a page break, etc. Try selecting just one object.

 

[tgambill]

Ok, that works for the text boxes. I also have check boxes in this section. The conditional formatting icon is grayed out when I select any of them.

 

[Alansidman]

This link may be a helpful tutorial video. Visually, you will see what Plog is expressing.

http://www.datapigtechnologies.com/flashfiles/linenuminreport.html

 

[tgambill]

That did it. Thank you to you both. I also changed the border to transparent so the clear lines do not have a border around them.