Coloring fields based on value

[scottvaughan]

Does anyone know how to set the color of a field based on its' value? Basically, I have a schedule. I have due dates. As the due date approaches, I would like to have the color of the due date filed change. Green if I have a week, yellow 3 days, red 1 day as an example.

[-Queue-]

Check the attachment for a sample solution.

DueDate.zip

[Lee Smith]

Hey JT,

Could you speed up your replies? LOL

BTW, the graphic is the old Generic Windows "Flag" so for us it doesn't show what you wanted.

Sorry to be the barrier of bad news.

Lee

[-Queue-]

Gah! I hate that. Does the newly-attached one work better?

[Lee Smith]

Yep

[scottvaughan]

How did you get the colors into the container fields?

[scottvaughan]

how do I get the new one?

[LaRetta]

Go to Layout 2. Copy the color swatch and paste it again on the layout. Change it's color. Then copy it (CTRL-C). Go to Browse and paste it in the correct repetition.

[Lee Smith]

Just download using the same Attachment, he changed it.

HTH

Lee

[NYPoke]

Goodness me, I don't want to call this hacking, but if I did, it would be a pretty impressive job of it.

Is this a standard use of a Container?

I've honestly never used a Container. I guess it was because I didn't know what to do with them.

[-Queue-]

Yes, container calculations are often used as visual flags.

[NYPoke]

Let's see if I get this. I could create 1 Global Container that contains Green, Yellow & Red.

I could then create a Container field for each important field I want to signal (Overdue Account, Posting Complete, Repossession) - all using the same Global Container field for my Color Signals.

Then, I can change the shape/size of the Per Field Containers on each Layout & Arrainge(sp?) them behind the field they are associated with.

Have I got the idea?

Anyway to place a Text/Number field directly into the Container, so that I don't have two buttons/fields on the layout?

[-Queue-]

Yes, yes, yes, yes, and no.

You can put a text/number field or a merge field on top of the container, so that it appears to be part of the container though.