June 5, 200619 yr Newbies 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.
June 5, 200619 yr 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")
Create an account or sign in to comment