craig_s Posted September 21, 2004 Share Posted September 21, 2004 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? Link to comment Share on other sites More sharing options...
Reed Posted September 21, 2004 Share Posted September 21, 2004 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. Link to comment Share on other sites More sharing options...
craig_s Posted September 21, 2004 Author Share Posted September 21, 2004 D'Oh! Thanks anyway. Link to comment Share on other sites More sharing options...
MoonShadow Posted September 21, 2004 Share Posted September 21, 2004 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. Link to comment Share on other sites More sharing options...
craig_s Posted September 21, 2004 Author Share Posted September 21, 2004 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 Link to comment Share on other sites More sharing options...
MoonShadow Posted September 21, 2004 Share Posted September 21, 2004 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. Link to comment Share on other sites More sharing options...
Lee Smith Posted September 21, 2004 Share Posted September 21, 2004 Take a look at this thread: Here Download the attachment by CobaltSky a.k.a. Ray J. Cologon HTH Lee Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7291 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now