1 Reply Latest reply on Mar 11, 2013 2:47 PM by philmodjunk

    How can we let text automatically decrease to fit into a field?

    Quirijn

      Title

      How can we let text automatically decrease to fit into a field?

      Post

                  
      •                
                            Hi, I wonder if it is possible to apply an automatic adjustment of text, when it doesn’t fit into a field, by decreasing its size (Like we can apply in MS Excel)?
                            (working on Apple - FMpro advanced 11)
                            Thanks, Quirijn
                  
      •      

            

        • 1. Re: How can we let text automatically decrease to fit into a field?
          philmodjunk

               Unfortunately, It's easy to count the number of characters in a field but not at all easy to measure the amount of space those characters will take. Keep in mind that iiiii takes up much less space than WWWWW, even though both represent 5 characters.

               Thus, you can set up a conditional format expression that uses the number of characters to reduce the font size used to display text in a field, but the result is crude at best.

               There is a way to use a sliding field and GetLayoutObjectAttribute while in preview mode to determine the Height need to display the text in the field, but this would require using a script and hidden special layout to do a "check fit" on the field.