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

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, 200818 yr by Guest

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.

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

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