Change fill color when results is x

[hcmbrbj]

I've got a calculation field set to a background color regardless of the results, which in this case is "Yes" or "nothing." I'd like for the field fill color to be different when the results is nothing. Is there a way to do this? If so, where can I find the RGB for the color I want if the results is nothing. When I say nothing, I mean it is filled with the current background but results is not displayed.

[Lee Smith]

Use Conditional Formatting.

[hcmbrbj]

: My bad. I'd done the conditional formatting, but failed to change the fill color on the layout itself.

[Makah]

Hi,

Here is one option, although I'm not sure if it's the best. You are on FileMaker 10 right?

1. Create a container field in the table that you are basing your background-changing layout on. You want to send it to the back of the layout, fill up the whole layout, and make sure it's not enterable in browse mode or find mode.

2. In your Resource table (if you don't have one, create one) you will create a global container that will be an image of your background color. Remember because it's a global, you're going to have to set the global field in a start up script. Let me know if you need me to elaborate on this.

3. In your original layout, you will set up an on object exit script trigger for the text field you care about. The script will look something like this:

If[Test::text = "Wrong"]

Set Field[Test::Background; Resources::Background_Wrong]

Else

Set Field[Test::Background; ""]

End If

Exit Script[Result; 1]

Hopefully this makes sense. I tried it, and it works for me.

Makah Leal

Soliant Consulting

http://www.soliantconsulting.com/apps/filemaker/