More than 4 Conditional Colors on Reports?

  • Thread starter Thread starter Chris B
  • Start date Start date
C

Chris B

I have a need to conditionally color-code some fields on a
report. The problem I have is that the Conditional
Formatting functionality only supports 3 conditions plus a
default, and I need to be able to color code 6 different
ranges of values.

Is there a way to dynamically specify the color (fill or
font) of a control on a report other than the Conditional
Formatting thing?
 
You do not need to use CF for Reports as a Format or Print event is
exposed for each row. Just place your code in the Format event to
determine which color you want and then set the control's color prop as
desired.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top