Change Field Color based on Value list Text (example) RH -Green Field

[Judy Brown]

I work for a Performing & Visual Arts School for the Disabled.

Some cannot read so we use color dots & initials (RH,ST)instead of numbers on a name tag to indicate which classroom they are to go to (10 classes per week.

How can I: 1)Change the color of a field by using a Value List.

2)Make the field look like a colored dot.

Can you help? Thanks

[BobWeaver]

There are a few ways to do this. Basically, you create your colored dots or any other graphic that you want, and paste them into container fields. If you have ten different colored dots, you can paste them into 10 different global fields, and then use a calculated field (with a container result) using a case function to pick the right one like this:

case(

MyData = 0,gBlack,

MyData = 1,gBrown,

MyData = 2,gRed,

MyData = 3,gOrange,

MyData = 4,gYellow,

MyData = 5,gGreen,

MyData = 6,gBlue,

MyData = 7,gViolet,

MyData = 8,gGrey,

gWhite)

where gBlack, gBrown, etc. are the global conainer fields where you pasted the dots.

[Judy Brown]

Hi Bob, Will I need to make 10 calculated fields to display all the color dots for each student? I am really green and still so much to learn. The dots on the name tags Mon AM & PM, Tues AM & PM, Wed AM & PM, etc for each student will correspond with the location of the classes the student takes.