Hilite single record

[Guest]

I need to change color, bold or italicize text in individual record based on
input from another record. Example; I have a list of vendors and need to
know at a glance which vendors are "Preferred" and which have been
problematic in the past.

 

[Rick B]

You don't say where you want to do this. In a form or a report, use the
built-in CONDITIONAL FORMATTING that allows you to change the appearance of
a control based on a value or condition.

 

[Guest]

But can you extend the colour changes of conditional formatting to the entire
row and not just the field with the value triggering it?

 

[Rick B]

You could do each control in the line. Make the controls large enough that
each one touches the one next to it so the whole line appears to be colored.

I think you could also create a rectangle and color it using conditional
formatting.

 

[Rick B]

Looks like you can't apply conditional formatting to a rectangle, you'd have
to use code. But, the other suggestion to apply the conditional formatting
to all the controls for the line is still accurate.

 

[Dirk Goldgar]

Looks like you can't apply conditional formatting to a rectangle,
you'd have to use code. But, the other suggestion to apply the
conditional formatting to all the controls for the line is still
accurate.

Stephen Lebans has posted code to do this. Poke around at
www.lebans.com .