Instead of MyTable::MyText, you want the result of the case statement to be styled?
Then simply put the case statement in place of MyTable::MyText
TextSize( TextFont( TextColor( Case ( IsEmpty ( MyTable::ResultCode ) ; " " ; not IsEmpty (MyTable::ResultCode ) ; "Faxed" ; "XXXX" ) ; RGB( 0 ; 125 ; 125 ) ); "Courier" ) ; 12)
1 of 1 people found this helpful
Seems like the calc itself should simply be this, because that's what the calc really boils down to.
There are NO cases when XXXX is the result.
Case ( not IsEmpty (MyTable::ResultCode ) ; "Faxed" )
Thanks for the help on the color setup.
Bruce I cut the case statement down as you suggested.
Have a good night