Bold when value outside of given range

[panosxap]

I'm trying to set up a FM database in order to store medical lab results of patients and hand them over a print out of their blood test results. How can I manage to have the font change automatically from normal to bold when a value is outside the normal range of values?

One more question: I have a calculated variable A, p.ex A = B-C-D, which is calculated after I give the values of B,C,D. I would like to have a message shown as value of the variable A p.ex. "not applicable calculation" in case the value of variable D falls outside a given range of values. Any ideas? Thank you.

[John Mark Osborne]

Use a Case statement and the TextStyleAdd function. Your formula might look something like this:

Case(MYFIELD > 0 and MYFIELD < 10; TextStyleAdd(MYFIELD; Bold); MYFIELD)

Use this formula in an auto-enter calculation attached to MYFIELD and make sure to uncheck the option to "do not replace existing value (if any)".

As for your second question, you would use a similar formula that might look something like this (except this will not be an auto-enter):

Case(D > 0 and D < 10; B - C - D; "Not Applicable")