Conditional formatting database results

  • Thread starter Thread starter Grecian2008
  • Start date Start date
G

Grecian2008

Hello i have a table Club that looks thus

CREF ClubName
Exe Exeter
Tor Torquay
Ply Plymouth

etc....

when i query this with
SELECT * FROM Club

i want to to display every record in a different font colour and /or
background colour depending on the result. There may be upwards of 100
records in the club table.

How is this possible?

I am using Frontpage 2003, Access 2003 and most of my database work is done
using the DRW in Frontpage.

Thanks
 
Hi Kathleen,

So if the db result is Exeter then 'Exeter' appears in red, if the result is
Torquay then 'Torquay appears in blue etc etc

thanks for your help.
 
Yeah i do and i've just thought how i could do it.

Create a column called FontCode and adjust the code for the db result field
so it read

<font color="<%=FP_FieldLink(fp_rs,"FontColor")%>">

this would work?
 
Back
Top