Gray Details and White Details 1

[Viracocha]

Hello all !!!

I want a gray background for a details and a white background for the next... i don't know how do this for a listing...


Thanks a lot and sorry for my poor english...

 

[pgtek]

Hi

To alternate background colors within a section, conditionally format the background color with a formula that uses the Remainder function.

Details Section
--------------

1. On the 'Report' menu, click 'Section Expert'.

2. Click 'Details' and then click the 'Color' tab.

3. Select the 'Background Color' check box and then click the 'X+2' button.

4. Enter the following formula:

if Remainder(RecordNumber, 2) = 0 then Red
else Yellow

5. Click the 'Save and Close' button and then click 'OK' to close the Section Expert.

When the report is refreshed, every odd numbered record will have a yellow background and every even numbered record will have a red background.


cheers

pgtek

 

[Viracocha]

Thanks a lot !!!

 

[Storyteller]

Hello Viracocha,

If you are looking to shade everyother row grey use this formula:

If Remainder(RecordNumber, 2) = 0
Then color(234,234,234)
Else nocolor

Regards,
Michael