3 Replies Latest reply on Mar 9, 2012 2:32 AM by GianandreaGattinoni

    Conditional Formatting



      Conditional Formatting


      FileMaker Pro



      Operating system version

      wondows 7, windows vista

      Description of the issue

      If a default formatting of a field has as style f.i. "italics" or "Bold" there is no way, applying a conditional formatting, to take out the default formatting and set it as "Plain".
      So, the format definitions defined in the "Conditional Formatting" window, do not reflect the final formatting that will be displayed.

      Steps to reproduce the problem

      Format a field with f.i. "Italic" or "Bold"
      Apply a conditional formatting with in "more formatting" just the "Plain" selection (I want to see the text as formatted "Plain").
      Look at the field when the conditional formatting is true and you will see that the format still presents "Italic" or "Bold", as default set

      Expected result

      The format has to reflect the settings as defined in the conditional formatting

      Actual result

      The default format setting remains (conditional formatting = false)

      Exact text of any error message(s) that appear

      No errors

      Configuration information

      any configurations


      if possible invert the formatting between default and conditional

        • 1. Re: Conditional Formatting

          Gianandrea Gattinoni,


          Thank you for your post.

          The behavior you describe follows the expected format "rules" for text in FileMaker Pro.  

          An important detail of this behavior is described in FileMaker Pro Help > Home >Designing and creating databases > Editing objects on layouts > Formatting text, as follows:

          "Field data that is formatted in Browse mode takes precedence over data formatting in Layout mode. For example, if you format field text as Bold in Browse mode, then switch to Layout mode and format the same field as Plain Text, the text will continue to display as bold. 

          Please let me know if I am misunderstanding your example in some way.  As I see it, you would like to be able to use Conditional Formatting to "reset" the formatting of a field, but if that format was set to "italic" or "bold" as default, it will not be changed when conditional formatting resolves as "true" for that field.


          FileMaker, Inc.

          • 2. Re: Conditional Formatting


            What Gianandrea Gattinoni describes happens even if no text is directly formatted at the data level.

            If the layout settings on the field specify Bold, conditional formatting cannot change it to Plain though, as Gianandrea has pointed out, the reverse can be done so we can usually work around this by reversing the logic of the conditional format expression.

            • 3. Re: Conditional Formatting


              PhilModJunk is correct.


              Moreover, let consider that if in Layout mode you format a text with Bold, In Browse mode you can format the same text as plain.


              That is not possible with Conditional Formatting.