Re: Color Coding

Dan wrote:
> All,
> 
> In the detail band of one of my reports there are three fields that always

> contain either a "Y" or "N" value.  In another field I
want to change the 
> color conditionally, when all three fields are "N" I want to use
a different 
> color for that field for that record.  What is the best way to accomplish 
> this?  Can I incorporate a Case..Endcase?

Use the canRender event, and simply:

     f = form.streamSource1.rowset.fields
     if f["fieldname"].value == "Y"
        this.colorNormal := "black"
     else
        this.colorNormal := "red"
     endif
   return true

For each text control, changing the "fieldname" to the name of the
field 
in question ...

Ken

-- 
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm

All,

In the detail band of one of my reports there are three fields that always 
contain either a "Y" or "N" value.  In another field I want
to change the 
color conditionally, when all three fields are "N" I want to use a
different 
color for that field for that record.  What is the best way to accomplish 
this?  Can I incorporate a Case..Endcase?

Thanks,
Dan