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

    Conditional Formatting

    GianandreaGattinoni

      Summary

      Conditional Formatting

      Product

      FileMaker Pro

      Version

      11.03

      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

      Workaround

      if possible invert the formatting between default and conditional

        • 1. Re: Conditional Formatting
          user15307

          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.

          TSTuatara

          FileMaker, Inc.

          • 2. Re: Conditional Formatting
            philmodjunk

            TSTuatara,

            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
              GianandreaGattinoni

               

              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.