2 Replies Latest reply on Jun 9, 2011 8:34 AM by philmodjunk

    forcing the font


      forcing the font


      1) Is there a way to force text imported into a field to automatically adopt a default text format: color, font, size, etc?

      2) Is there an easy way to standardize fonts that are already in fields?

      Thank you!!

        • 1. Re: forcing the font

          Most of the time, you should be storing plain text and any formatting is applied at the presentation (aka layout) level.

          If you actually want to store formatting text, ou can define an auto-enter calculation that applies text formatting functions to Self. See FileMaker's help or a calculation box fucntion drop down for a list of text formatting functions.

          • 2. Re: forcing the font

            You can use this calculation in a replace fields operation to strip the formatting out of existing records or records that were just imported. You can also use it as an auto-enter calculation to strip out the formatting during import if you enable auto-enter options during import:

            TextFormatRemove ( Table::FieldName ) //in replace field contents

            TextFormatRemove ( Self ) // as an auto-enter calculation.

            Also clear the "Do not replace existing value..." option when setting this up as an auto-enter calculation.