Hello

I have a calc field called. (colors) and there is a list of codes.

1=red , 2 =blue , 3+ yellow etc.

what happens when I want to use 2 or more colors.

what would then be the calculation if the answer which triggers the calc were as follows'

1, 3

and the colors then would be red and yellow

or 1 would just be "red"

and 1&2 would just be red and blue

I am not sure how to write this and furthermore I would like the colors bold and the actual color I am naming. Is that possible.

Thanks

DAVE

I am not sure I understand the question. Could you rephrase it and/or post a sample file demonstrating it?

Sure I have a database which I have to automate text answers but sometimes there is more than one answer. So I wanted to write a script that would respond to whatever I put in a field called (codes).

If I put the number 1 in the (codes) field then the field colors would say "RED"

If I put the number 2 in the (codes) field then the field colors would say "Blue"

If I put the number 3 in the (codes) field then the field colors would say "yellow"

But if I have the numbers 1 and 3 in the field codes , the field colors should say RED, YELLOW

or if I have the numbers 1,2, 3, in the field (Codes) , then in the field colors it should display RED, BLUE , YELLOW

I also wanted the words to be the colors they were naming. So the word RED would be RED and the word Blue would be blue and yellow would be yellow, But Black would be bold.

I would those things to happen from a script.

Thanks

DAVE

See how the attachment works for you. This seems to require a script, unfortunately, because value lists do not maintain field formatting info.

CodeColors.zip