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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Different background colors for invoice line items 3

Status
Not open for further replies.

Mack2

Instructor
Mar 12, 2003
336
US
For an invoice I need to have every other line to have a shaded background. It will help seperate the line items on the invoice. So another words, the first item will have just the normal white background, the second line item will have a gray shaded background, the third will go back to a white ect. Thanks for your help!
 
Go to Report, Section Expert.
Highlight the Details section on the left.
Click the Color tab in the upper right.
Click the X+2 button and enter the following in the editor:

if recordnumber mod 2 = 0 then
Color(239,239,239)
else
crWhite

Save and close.
I used the color function to return a specific shade of gray. You can use crGray, or crSilver if you like, or even adjust the values in the color function. For gray, keep all the numbers the same, and increase them for a lighter shade, or decrease them for a darker shade.

~Brian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top