1 Reply Latest reply on Sep 4, 2010 6:53 AM by sunmoonstar.13

    Formating by Character Count



      Formating by Character Count


      I have a print report layout which I would like filemaker to reduce the font size by the a certain number of characters. I know you can do this in conditional formating but I need some assistance in the calcualtion. Any ideas?

        • 1. Re: Formating by Character Count

          Specify the following formula for the conditional formatting on your field:


          Length ( your_Table::your_Field ) > 10


          Then click the "More Formatting" button in the Conditional Format dialog box and select the desired font size.

          If the field has more than 10 characters, the font will then be reduced to the font size you've set.

          You can change the "10" in the formula to whatever number of characters you want.