Conditional formatting database results

[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

 

[Kathleen Anderson]

Need more information - what does "depending on the result" mean?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Grecian2008]

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.

 

[Kathleen Anderson]

Hmmm. That's a challenge. Do you have flexibility with the database design
that you could add two fields to store the background and font colors that
you want for each record?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Grecian2008]

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?

 

[Kathleen Anderson]

That's what I was going to try when I got to work this morning - let us know
how it goes

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Grecian2008]

It works! Thanks Kathleen!!

That's what I was going to try when I got to work this morning - let us know
how it goes

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Kathleen Anderson]

Great! Thanks for letting us know!

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others