hundy Posted April 10, 2005 Share Posted April 10, 2005 I'm working with FileMaker Pro 6 and am have the following calculation: If(ACERTAINFIELD>=50, "YES", "NO"). What I would like to do is have FileMaker return the NO in red so that it stands out when looking at a list with many pieces of data. Is it possible to have the font attributes dependent on the results of a calculation? Link to comment Share on other sites More sharing options...
Maarten Witberg Posted April 10, 2005 Share Posted April 10, 2005 In version 7, this is possible directly. In v6 and earlier, you need to resort to a little trickery. See the sample posted here . kjoe Link to comment Share on other sites More sharing options...
Robert Schaub Posted April 10, 2005 Share Posted April 10, 2005 For those using 7 try it this way. Code: Case ( ACERTAINFIELD TextColor (Job Name ; RGB ( 0 ; 0 ; 0) ) 49 or less will return red text , 50 or higher will defaualt to black text. Link to comment Share on other sites More sharing options...
hundy Posted April 12, 2005 Author Share Posted April 12, 2005 Thanks for the help. This should work for my purposes. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.