Format text via a Calculation?

[zenman]

Can I perform a calculation with the result being a different text format?

Example: if a test score < 70 can the result be, format the text in Red, and all values equal to or greater than 70 be displayed in Black.

Help! and Thanks in advance for your answers!

[zincb]

You can create two calculated fields,

Test_Score_Red = Case ( Test_Score < 70 , Test_Score, "" )

Test_Score_Black = Case ( Test_Score >= 70 , Test_Score, "" )

On your layout, give the topmost one (the one created last) a transparent background and give the bottom-most one an opaque background. Align them center to center & make sure they are same size & format with exception of text color.

This will give the appearance of what you ask, but you need to actually enter the test score in the "real" Test_Score field, somewhere else.

[DMouse]

Also do sliding up (reduce size of part) so that only one of the two choices will show in you preview or printed page.

[LiveOak]

(I'll try this post again. Almost had it done when zNET went down for 4 hours, so much for their ever improving (lately declining) QOS.)

You can go one step further and stack the entry field under the two calculated fields. Make the bottom calculated field opaque white. Disable "allow entry into field" in Field Format. Even though they are calculated fields, this will prevent them from being selected when you click on the stack of fields for data entry. When you click on the stack, you will be taken to the bottom (entry) field and be able to enter data.

-bd

[zenman]

Thank you for your help! I used all of your advice and it worked perfectly, I read about formating text in FilMaker Pro 5 Companion and the Quickpro guide and my text always came out funky. You guys had the missing links for me, thanks a million. I took FileMaker classes but they realy fell short on scripting and calculations basically wasted time and money.

Thanks Again,

John