Hello <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Ive searched and searched and still havent found the answer, fingers crossed someone here can help me with this.

I would like the font color of a displayed record to change depending on whether 4 other records contain a certain word.

For example :

rsOverview.Fields.Item("steplabel".Value) is displayed, font color = green. If

rsOverview.Fields.Item("hz1ccpex".Value) OR
rsOverview.Fields.Item("hz2ccpex".Value) OR
rsOverview.Fields.Item("hz3ccpex".Value) OR
rsOverview.Fields.Item("hz4ccpex".Value) = "certain_word"

Then change rsOverview.Fields.Item("steplabel).Value) font color = red.

Did that make sense?! Basically "steplabel" is displayed on this page in green, if hz1ccpex or hz2ccpex or hz3ccpex or hz4ccpex contain the value "certain_word", "steplabel" needs to change to red. If none of the hz*ccpex contain "certain_word" then nothing happens and it stays green.

Ive trawled the posts on conditional statements, one of which gave me an idea but instead of changing the text color it was changing the table cell color. Needless to say I still couldnt work it out!

Many thanks to anyone who can comment/help.

Adam.

This should get you close to where you want to go. This is based on one field in a database. I had to trim it up, because of several variations of what could be in the field. The variations I was looking for was anything beginning with "Positive".


I put the following above my header code:

&lt;%
Dim Pozitive
%&gt;
&lt;%
Dim trimname
%&gt;

In my dynamic table, I did the following to make the result RED.

&lt;%Pozitive=RS1.Fields.Item "Results".Value%&gt;
&lt;%trimname=left(Pozitive, 8)%&gt;
&lt;%If trimname = "Positive" Then%&gt;
&lt;Strong&gt;&lt;font color="#FF0000"&gt;&lt;%=(RS1.Fields.Item("Results".Value)%&gt;&lt;/font&gt;&lt;/Strong&gt;&lt;/td&gt;
&lt;%end if%&gt;
&lt;%If TrimName &lt;&gt; "Positive" Then%&gt;
&lt;%=left((RS1.Fields.Item("Results".Value),20)%&gt;&lt;/td&gt;
&lt;%end if%&gt;

Hope this helps.