Color Coding Pop up menu selections

[dnewberger]

Hello All,

I have been wroking on one problem for a few days now and don't know where else to look so I am hoping you guys can help me figure this out.

I have a pop up menu called Priorty it has a valuse list of 1-5 What I am trying to do is get each one of these numbers in the field or the background of the field to be a differnt color to denote the importance of the issue i.e.

1=red

2=orange

3=yellow

4=blue

5=green

Thxs in advance

Dave

[LiveOak]

Two options:

1) To make the field contents change color, you will need to stack 5 calculated fields on top of your entry field. The bottom CALCULATED field should be opaque, the rest of the calculated fields transparent and formatted to display in different colors. Set the calculated field to not allow entry (I know, you can't anyway), this will cause the bottom entry field to be selected when you click on the stack of fields. Take the calculated fields out of the tab order. Each calculated field would look similar to:

Display1 (calculation, text) = If( EntryField = 1, EntryField, "")

Display2 (calculation, text) = If( EntryField = 2, EntryField, "")

.

.

2) Create a repeating container field to store your five colors. Copy colored rectangles you draw in layout mode and paste them into the container in browse mode. You can format how they fill a container field with the "Graphic" formatting menu item. Create a calculated background field to put behind the entry field (entry field must be transparent) as follows:

BkgdField (calculation, container) =

Case(

EntryField = 1, GetRepetition(ColorContainer, 1),

EntryField = 2, GetRepetition(ColorContainer, 2),

EntryField = 3, GetRepetition(ColorContainer, 3),

EntryField = 4, GetRepetition(ColorContainer, 4),

EntryField = 5, GetRepetition(ColorContainer, 5),

"")

The colors must be in the repetitions in the correct order.

-bd