Setting color of contain or fill of field with rgb

October 31, 200520 yr

I am trying to set the color of a container field or the fill/background color of an edit box based on the rgb numbers.

Fields

RGB - text field contains rgb number (84:00:17)

should I split this into 3 fields

Color - storage or text field.

I need to set the fill or background color of Color field with the rgb info from RGB field.

Thanks

October 31, 200520 yr

Hi, J!

Anything like this as in attachment?

Fill.zip

Edited October 31, 200520 yr by Guest

October 31, 200520 yr

Hi aaa

your calc for Fill_calc isn' corret when someone enter only one or two digit for a color !

This is better:

TextColor ( SYMB ;

Evaluate ( "RGB" & Substitute ( LeftValues (RGB_Text; 1 ); ":" ; ";" ) )

)

BTW here it's my attachment

Fill2.zip

October 31, 200520 yr

Yes, raybaudi! It is better. I was think about this after posting. But because the main goal was how create filling i did not change post. But your note is very important and usable. Thank you.

October 31, 200520 yr

Author

What is the Symb field for? What data are you sticking in there?

October 31, 200520 yr

The SYMB field is a text field that holds the Arial character "Full Block" (Unicode 2588)which is the following character: █

It is what the name implies, a full block. Since Filemaker has yet to offer the abilty to change a fields background color you must create a container field that holds text like such:

███████████

By placing a number of these characters in a container field you can change the color of the text. It takes some trial and error to get everything sized right but does work.

You can see a list of the characters available for each font by using Start>Programs>Accessories>System Tools>Character Map