Background colour in a continuous form

[greymonkey]

Hi there,

I have a subform which is showing the records in continuous forms.

i am trying to get the background colour to alternate between records so you get a sort of stripy efect.

all my efforts so far just change the background colour for every record.

any ideas.

cheers,
GrayMonkey
:>

 

[DreamerZ]

Try this:

Private Sub Form_Current()
MyColor = Int((255 * Rnd) + 1)
MyColor1 = Int((255 * Rnd) + 1)
MyColor2 = Int((255 * Rnd) + 1)
Detail.BackColor = RGB(MyColor, MyColor1, MyColor2)
End Sub

Putting the color change in the Form_Current() section causes the color to change on form opening and when displaying new records. That's from "BackColor Property" in Access help.

Hope that helps.



DreamerZ
simplesolutions@prodigy.net
[ignore]

http://www.geocities.com/simplesolutions@prodigy.net

[/ignore]

 

[DreamerZ]

I reread your post and my solution won't work. I see now what you want to do. I'll let you know if I find anything else.

Sorry!


DreamerZ
simplesolutions@prodigy.net
[ignore]

http://www.geocities.com/simplesolutions@prodigy.net

[/ignore]

 

[GKProgrammer]

Hi greymonkey,

While there is no obvious solution there is one and it takes a little bit of work to implement but it is easy to do. I found an example db on the net for download some time ago, which is how I learned to do this. Follow the below link and download the ColorCon.zip and it will show and explain to you how to do this. Hope this helps.

http://www.mvps.org/access/forms/frm0024.htm

Regards,
gkprogrammer