If data is under a certain number

  • Thread starter Thread starter Dennis Villareal
  • Start date Start date
D

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
 
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]...
 
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
 
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.
 
Back
Top