3 Replies Latest reply on Jan 25, 2015 6:49 AM by philmodjunk

    Strange Font Issue



      Strange Font Issue


      Hi - I have a strange problem where I have set a font (Verdana) to a field but when I view the records in browse mode some of the records have remained in the old font (see image). I have tried changing to another font but the same records remain unchanged. There is no conditonal formatting applied to this field so I am at a loss to understand why it is changing only for some records. I am using FMP 12


        • 1. Re: Strange Font Issue

          There are two ways that text can be formatted. You can select a field while in layout mode and specify a format--whether conditional or just in the inspector.

          Or you can format specific text in the field--either by selecting the text and applying a format from the formatting tool bar or by pasting formatted text from another source.

          The format applied directly to the text supersedes the format specified for the field while in layout mode.

          To remove the format from existing data, use TextFormatRemove ( fieldNameHere ) with the replace field contents tool (show all records first). To keep out such formatting in the future, set up TextFormatRemove (Self) as an auto-enter calculation with the "do not replace existing value..." check box cleared.

          • 2. Re: Strange Font Issue

            Thank you for your reply, it was very helpful. Another way I resolved the issue was by deleting the text and then re-typing it. For some reason this triggered the font I had selected in layout so I can only imagine it was some form of refresh issue. But once again thank you for your reply which will be useful in future

            • 3. Re: Strange Font Issue

              Retyping can definitely remove a text format applied to the data being retyped. It will just take a while as your are fixing the problem one character at a time while my suggested methods do it all in a "Batch" operation.