Jump to content

Color a field depending on date or value


This topic is 5739 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5739 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.