BackColor Coding

[Ian]

I have a continuous form and I'm using an "If" statement
saying that if a field contains a certain value, set the
BackColor property of the field to a particular colour.
The problem is that it sets the back colour for all
records whereas I only want it to set the back colour for
individual records where the "If" statement is true.

I have used Conditional Formatting but it only allows for
3 conditions. The field I'm using has many values.

Thanks to anyone who can help
Ian

 

[Wayne Morgan]

The only examples I know of are by Stephen Lebans. See if any of these do
what you're needing.

http://www.lebans.com/conditionalformatting.htm
http://www.lebans.com/conformscurcontrol.htm
http://www.lebans.com/alternatecolordetailsection.htm
http://www.lebans.com/formatbycriteria.htm