Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Set BackGroud Color for every other Row
- Thread starter rasprer
- Start date
I use the following in my reports
from the design canvas, right click on the detail section located on the left and click on format section. Click on the color tab and click on the x+2 button next to the background color and add the following formula
-LW
from the design canvas, right click on the detail section located on the left and click on format section. Click on the color tab and click on the x+2 button next to the background color and add the following formula
Code:
if remainder(RecordNumber,2) = 0 then
//Pale Green
color(231,255,210)
else
nocolor-LW
Thank you for this information!
Oh, and if you want to use a different color than Pale Green, you can get the color coordinates by accessing the custom color grid (by checking the "background color" box) from the drop down menu (choose "More...")
Moving the cursor around will show the RBG refrence numbers used for the above formula.
Oh, and if you want to use a different color than Pale Green, you can get the color coordinates by accessing the custom color grid (by checking the "background color" box) from the drop down menu (choose "More...")
Moving the cursor around will show the RBG refrence numbers used for the above formula.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question