I want to change the fieldcolor after inputting specific data in a
field.
Is there a script command which can do this.
I only found RGB( ) to change the textcolor of an individuell
textinput.
But how can I change the fieldcolor of an individuell
field? I use FM8.

Any ideas?

Hermann

See script possibilities under "conditional formatting FP ver 7" thread.
Michael Paine

Hermann Siemandel wrote:

Hermann Siemandel wrote:

Just so I understand correctly, are you talking about coloring the text
(which can be done through scripting, see Text Formatting functions in
Help) or coloring the background of the field (which is not a native
function, but relatively simple to do)?

Matt

That is what we did through FMColor. We changed the "text" color with
a calculation. You can see the results at:
http://www.fmwebschool.com/fmcolor.php

In Kindness
Stephen K Knight

Unfortunately, there is no function in FileMaker Pro which will let you set
the background color of a field. You can only set the color of text.

TextColor(MyField;RGB(255;0;0))

For example, returns the contents of the field "MyField" as red.

If you need to set the background color of a field, there are two methods to
doing this.

- The first is to use graphics. You set your actual input field to have a
clear background, and immediately behind that, you place a container field
of the same size. Using a relationship or calculation, you swap in the
appropriate color fill into the container field.

- The second method is to use text. For example, "nnnnn" in the 36pt
Webdings font, Bold, Compressed will give you a solid-looking bar. You can
set the color of the "nnnnn" to whatever you like (using the TextColor()
function). Again, this field must be placed behind the actual data entry
field, which is set to transparent.

Both have advantages and drawbacks.

It would be nice if FileMaker had an option when defining the color of
something to use a "calculated value," as it does for tooltips.

Bill

"Hermann Siemandel" <h.siemandel (AT) nefkom (DOT) net> wrote

You can get some of the effect of a calculated value by using an
auto-enter on your text field. So, for example, if your color values
are in fields Red, Green, Blue then you can do an auto-enter replace
existing of

TextColor(text;RGB(Red;Green;Blue))

This will recolor the text whenever you change one of the colour fields
Red, Green or Blue.