data on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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