Simple color calc

[cmack]

Hopefully this has an easy answer. I would like to make the wrong answer show up in Red.

I have 2 fields Answer1 which has the student's answer in it. The answer is a letter (A-E)

The second field CorrAns has a Y or and N indicating if the answer1 is correct or not.

So if CorrAns = "N" I want Answer1 to be colored red otherwise it will be the default text color for the field.

Hopefully I made this clear. I am not sure if I use case or if for the calculation and not sure how to complete it.

Thank you for your time.

CMACK

[Lee Smith]

I guessing that you are using the Auto Enter on the Answer Field.

Case ( CorrAns = "N" ; TextColor ( Answer ; RGB ( 250 ; 0 ; 0 ) ); TextColor ( Answer ; RGB ( 0 ; 0 ; 0 ) ))

If you want a Demo, I can post one.

HTH

Lee

Edited January 17, 2008 by Guest

[cmack]

I am not using auto enter any where. I import all the data from another file. But I think what you have above is what I was attempting to do.

I am going to try it right now.

Thank you very much.

[Lee Smith]

You can not import into a calculation field.

The Answer Field would have to be text, in which case, you would have to create a second field for the text color change, or use the Auto Enter Function.

here is a small demo of the field. Check the Options I used, and be sure that you "Deselect" the box under the Auto enter that reads "Do not replace existing values (if any).

Lee

cmack.fp7.zip

[cmack]

Lee,

That worked perfectly. Thank you for taking the time to help. I always try to search for what I am looking for before asking but I never seem to use the correct terms or I end up with things way more complicated then I need.

I appreciate your time.

CMACK