How do I change text box color to entire row in Access 2003

[Damaryllis]

I have a report and have set the conditional control of total earning to be
red if less than 25000, blue if between 25000 and less than 50000 and Gray is
greater than 50000. How can I make all of the text boxes in the row match
the colors.

 

[fredg]

I have a report and have set the conditional control of total earning to be
red if less than 25000, blue if between 25000 and less than 50000 and Gray is
greater than 50000. How can I make all of the text boxes in the row match
the colors.

Use Conditional Formatting on EACH of the other controls.

Condition1
Expression Is
[TotalEarning] < 25000
Set the color to Red
Condition2
Expression Is
[TotalEarning] >= 25000 and < 50000
Set the color to Blue
Condition3
Expression Is
[TotalEarning] > 50000
Set the color to Gray

Make sure the BackStyle of each control is set to Normal.