Hi everyone-

This may be a question for the script message board, but I wasn't sure if a script was needed. I was wondering if it was possible to automatically change the background of a particular field depending on the data in another field.

I've created a database that log information going in and out of our office. There are three fields; 1)date the question goes out, 2)date response is returned, and 3)the reponse. I'd like to make the response field automatically turn a different color when a response has not been received yet. Is this possible?

Thanks in advance.

You will need the following.

A global container field with at least two repetitions. (Colour [global, container, 2 repetitions] )

Then a calc field (unstored)formatted as a container.

Case (IsEmpty( Response Returned, GetRepetition(Colour,2), GetRepetition(Colour,1)

Thanks for the response Andy. I tried what you said and it worked. However, I don't think I was clear enough in my original post. In the 3rd field "response," we will input the response that we receive in text format. I'd like the color change to be in the background, behind the text. Am I missing something from the fields you explained or is this even possible?

You simply lay the actual response field ontop of your color field. Then make sure that the response field is transparent, and that the color field is not enterable.

If my "response" field is set to "slide" when I print and I put the colored field behind it, is it possible to make the colored field slide the same amount as the "reponse" field?

If you have a color behind an empty response field, and no color behind a filled response field, sliding shouldn't happen -- you'll always have something in that space. I'd get rid of the "sliding" feature for the field, since it can only screw up the layout of your printout.

Thanks for the help.