conditional format for more than 3 values?

  • Thread starter Thread starter sixschultzz
  • Start date Start date
S

sixschultzz

How can I conditional format for more than 3 values in Access report?
i.e. I have 5 lines of data (numbers) and want them to highlight upto 6
specific of those numbers when the criteria (which changes daily) is met.
 
sixschultzz said:
How can I conditional format for more than 3 values in Access report?
i.e. I have 5 lines of data (numbers) and want them to highlight upto 6
specific of those numbers when the criteria (which changes daily) is met.
Click to expand...


Without knowing what you mean by "the criteria (which
changes daily) is met", all I can say is to use a calculated
field in the report's record source query to determine if
the criteria is met. Then you can use CF on that calculated
field.

If CF can not be made to do whatever it is you want, you can
use report section events to do that (unlike continuous or
datasheet forms).
 
Marshall,
Thanks for the response. My criteria consists of multiple price amounts
that we are trying to track the frequency of occuring from day to day; hence,
the change daily. But I have posted in my database the amounts we are
tracking and I was just going to change the value of the conditional data and
have it highlight the amounts. I hope this makes a little more sense.
 
sixschultzz said:
Thanks for the response. My criteria consists of multiple price amounts
that we are trying to track the frequency of occuring from day to day; hence,
the change daily. But I have posted in my database the amounts we are
tracking and I was just going to change the value of the conditional data and
have it highlight the amounts. I hope this makes a little more sense.
Click to expand...

Not really. But let me suggest that you use some code in
the section's Format event procedure: (just guessing here)

Select Case price
Case Is < price1
Me.sometextbox.BackColor = vbRed
Case Is < price2
Me.sometextbox.BackColor = vbYellow
Case Is < price3
Me.sometextbox.BackColor = RGB(255, 220,220) 'pink
. . .
Case Else
Me.sometextbox.BackColor = vbBlack
End Select
 
Back
Top