Color a field depending on date or value

[darrel]

G'day,

I've searched the forums but haven't seen a similar problem to the one I have.

My problem is that I have to change a number of yearly calendars. I want to be able to quickly change some dates and values so the field box (not the text) changes color.

I'm not sure what is the best way to tackle this.

eg

Fields: Date, ColorFlag

Values would be like:

01/01/06 = workday

02/01/06 = holiday

Using calcs and container fields with repetitions, color the field box 'Grey for work a day' and 'yellow for a holiday'.

This way I could quickly change a date from a work day or holiday and the field colour box would change.

Hope this makes sense. Any suggestions would be appreciated. TIA

Cheers

Darrel

[Genx]

I just make a calc with result container and place it behind my main field... i.e.

Case( xxx = "workday" ; gHighlightYellow ;

xxx = "holiday" ; gHighlightRed ;

"" )

where gHighlightYellow and gHighlightRed are just container fields with global storage turned on and that have a coloured square within them...

Hope this helped.

~Genx

[Inky Phil]

Hi Darrel

There is a sample file of the technique that Genx suggested here

http://fmforums.com/forum/showtopic.php?tid/175068/post/198464/hl//#198464

Phil

[darrel]

Thanks everyone,

I'll take a look at the example file.

Much appreciated :