Change BGround Row Color depending on a Value in a Database field

Change BGround Row Color depending on a Value in a Database field

Post by U3R1YXJ » Tue, 19 Apr 2005 05:31:03


I have a Database of Staff and in the database is a field Called fldtype.
I have a table that show all the staff but it all start to blend in to a
mess just looking at same colours for everyone.

I have got the code to give alt row a different color and that helps but
what I really want is some code that will change the Bcolor and or Text color
depending on the field value contained in "fldType"

IE: If fldtype="Teacher" then Color red or if fldtpye="technician" then
color Green else if fldtype="Admin" then color orange.

Do you get what I mean.

I am new to this as I am a Netowrk man not a Web Coder but my School asked
if I could help out as site needs a major over haul.

Web editor being used is FP2000 and FP2003 at home.

Thanks
Sturt
 
 
 

Change BGround Row Color depending on a Value in a Database field

Post by Thomas A. » Tue, 19 Apr 2005 05:41:11

Can you paste the code that show how you are displaying the records?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.yqcomputer.com/
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.yqcomputer.com/