changing colours of records

[martin]

Easy one for somebody

How do I change the backcolor of a whole record in code. I
know how to do this for a field eg
Me.Text1.BackColor = 255
however I don't know how to do the whole record. What I
want to do is change the colour of a record based on the
value of a field.


Thanks in advance

Martin

 

[Cheryl Fischer]

Go here: http://www.lebans.com/conditionalformatting.htm and download
Stephen Lebans' sample database of conditional formatting techniques. In
the database, see the form "cusContinuous" for how to do it.