If data is under a certain number

[Dennis Villareal]

i would like my report to show data a different color if it is below a
certain number.

we have a field that needs to be at least 23 this is shown on the report. i
would like the color to be "RED" if it is below this number. how can this be
done?

this is pulled from a query and in the report it is a Text Box where the
control source is YLD

thanks

 

[Allen Browne]

Use conditional formatting (assuming Access 2000 or later.)

In report design view, right-click the text box and choose:
Conditional Formatting

Set up condition 1 for less than 23.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[roccogrand]

HI Allen,

Does a textbox in a report maintain its fill color like a textbox in a form?
A calculated value shows the correct color as defined by conditional
formatting but not the box itself.

Access 2007.

David

 

[Allen Browne]

So the text changes color, but the background color of the box does not?

In the conditional formatting dialog, use the bucket icon to set the
background color.