More than 4 Conditional Colors on Reports?

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?
 
S

Stephen Lebans

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change text box background color depending on value in Label Reports 1
Excel conditional formatting with Weeknum 4
Can data be in different colors on reports? 1
Strange conditional formatting behavior 3
Conditional Format Does Not Print 9
More than 4 formatting conditions-cross-tab report 1
Conditional Formatting on client 11
Conditional Format 3

Top