hi i was trying to make kind of a status page: now i have a table which displays the status and a tex: as example

done - green
not finished - red
progress - blue

how can i assign a color and a text to the table so based on the condition of the database entry the table would have a diffrent color, and the right text in it.

hopefully someone has an answer for me

best regards
Anton Sutterlueti

Something like:

<font<% If (RecordsetName.Fields.Item("ProgresField".Value) = "done" Then %>color="#009900"<% End If %><% If (RecordsetName.Fields.Item("ProgresField".Value) = "not finished" Then %>color="#FF0000"<% End If %><% If (RecordsetName.Fields.Item("ProgresField".Value) = "progress" Then %>color="#0000FF"<% End If %>><%= (RecordsetName.Fields.Item("ProgresField".Value) %></font>

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo