How to do this...

[craig_s]

HI

I was wondering if it is possible to do the following. I would like the text colour in one field (a text field) to change to a different colour based on the selection from a drop down menu in another field. The colour it changes to needs to be different depending on the selection made in the drop down menu ie, in drop down menu selection made is "A" colour in text field changes to red, "B" colour changes to green. Can this be done? If yes, how?

[Reed]

It can be done.... using the text formatting functions available in filemaker pro 7. I don't know if there's a way to do it in filemaker pro 6.

[craig_s]

D'Oh!

Thanks anyway.

[MoonShadow]

If you are interested only in the 'display' of color and not actually changing the field contents, you can stack a calculation field.

Create a calculation (text, unstored). Enter something like:

Case(DropDownField = "B", TextField)

Take TextField and copy it. Change TextField to green text. Take the copy, double-click to bring up Specify Field and change it to the calculation you just created. Change its fill and pen patterns to transparent (right-click then select fill pattern. Select top-left square, repeat with Pen Pattern). Then change its font color to red. Right-click it again and select Field Format and unclick 'Allow Entry.'

Then select them both by either dragging around them or select both while holding down [shift]. Select Arrange > Set Alignment > Center-to-center. This way, they will match exactly in size, font size and placement. The calculation will stay on top (where it needs to be) because it was created after your original TextField.

When you change selections in the popup, the color of your TextField will change accordingly.

[craig_s]

Hi Moon,

Thanks, I will try this and see if I can Actaully make it work (not the world's most competent FM person) Will let you how I go.

Cheers

Craig

[MoonShadow]

Apologies. The calculation for red (or A) should be:

Case(DropDownField = "A", TextField)

I figure you would work that out but I wanted to be sure. This is the calculation you want red, so it should have been A not B. Sorry for the mis-type.

[Lee Smith]

Take a look at this thread:

Here

Download the attachment by CobaltSky a.k.a. Ray J. Cologon

HTH

Lee