Dispaly alternate coloured records on List

[Bee]

Hi,

Is it possible to display records in different colours in a list? e.g. 2 colours: first line will be colour 1. Second line will be colour 2. third line will be colour 1...etc

Regards,
B

 

[Bee]

Sorry guys. I did not mean to send this thread twice. My browser returned an error. When I refreshed the page, i realised it was sent twice.

 

[ColinEssex]

I think I have some code that will show alternate green lines on a report (like the old continuous printer paper). Is that what you need?

I couldn't find your other posting to see if you had a result in there.

Col

 

[Bee]

I think I have some code that will show alternate green lines on a report (like the old continuous printer paper). Is that what you need?

I couldn't find your other posting to see if you had a result in there.

Col

I am not using the list on a report yet, but I may need your code if that's ok.
My list is on search form, it shows records returned by a query; and I want these returned records to appear in alternate colours.

Do you know if that's possible?

Regards,
B

 

[Ron_dK]

B,

You might do a search on "conditional format" on this forum.
This might give you an idea of changing back ground colors in reords or fields.

Hth

 

[Bee]

B,

You might do a search on "conditional format" on this forum.
This might give you an idea of changing back ground colors in reords or fields.

Hth

rak,

Ok, Thanks.

Regards,
B

 

[AN60]

I have used the following in the OnPrint event in the Detail section of numerous reports. You can easily fiddle with the numbers to get your prefered colours. Colours in this example are very pale because I don't want to use excess ink or toner when I print the reports but they are sufficient to make readability better. H'mmm, I'm not sure about the "Light Grey" number but give it a go, you can't get into much trouble.

If Detail.BackColor = 16777215 Then
Detail.BackColor = 14811135
'14811135 = Light yellow. 15263976=Light Grey
Else
Detail.BackColor = 16777215
End If
End Sub