data on report

[Jettron]

I have a field in my database where I enter a particular number for each record
I would like in a report to show all these numbers in one color & the ones
that fall within a certain range (2.5 to 3.5) to be in another color
how can I do this
I'm new to access
thanks

 

[fredg]

I have a field in my database where I enter a particular number for each record
I would like in a report to show all these numbers in one color & the ones
that fall within a certain range (2.5 to 3.5) to be in another color
how can I do this
I'm new to access
thanks

AWhat Access version? Access 2000 or newer?
You can use Conditional Formatting on the control in the report.
Select the control. Click on Format + Conditional Formatting.
Set Condition1 to
Field Value Is
Between 2.5 and 3.5

Select the color.
Save the changes.