Jump to content

Bold when value outside of given range


This topic is 5661 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • 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.

Link to comment
Share on other sites

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")

Link to comment
Share on other sites

This topic is 5661 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.