Printing Question

[lmf232s]

I have a report that i alter the color of each line.
As well the final total at the bottom of the page has
a grey background.

It would be something like this.

1,000.00
2,000.00
1,000.00
2,000.00
6,000.00

but would display like this
1,000.00
2,000.00
1,000.00
2,000.00
6,000.00


I am going to print on a black and white printer and i know
i can not keep the color but is their any way to get it show
it shows up as different shades of black/grey and white.

I have an excel page that has one rows bgcolor in light grey and
when you print that page it prints with a light grey background.

i can not seem to figure out anything. I have set the bgcolor of the
<tr> the <td> tags and nothing.

Does anyone have any idea.

[lmf232s]

well this seems to work, i just created a grey image, and will set
the image as the background of the row and then it will print a
grey scale color for the background.

[russell]

lmf232s, I'm assuming in the following example that you are looping through an array:

dim bgcolor

For i = 0 to ubound(myArray, 2)
If i mod 2 = 0 Then
bgcolor = "#cccccc"
Else
bgcolor = "#ffffff"
End If

Response.Write "<tr bgcolor=" & bgcolor & ">" & vbCrLf
...
Next

[russell]

Sorry, I really should have READ your post before responding. Printing backgrounds is a printer setting, local to the users machine. Maybe CSS can set it for you, but I don't think so. So your bg-image solution was probably the best you can do without access to the end user pc.