1 Reply Latest reply on May 29, 2013 6:55 AM by philmodjunk

    Changing Fonts automatically



      Changing Fonts automatically



           I have quite a large database where alot of the information is going to be copied and pasted straight into it


           Is there a way for that information to automatically to become "Arial, size 15 and colour black"?



        • 1. Re: Changing Fonts automatically

               Take a look at the text formatting functions. You can set up an auto-enter calculation to reformat the pasted data.

               Option 1:

               Define the text field(s) with: TextFormatRemove(Self). Then use layout settings to format the field with the desired format.

               Option 2:

               Use the other text formatting functions to specifically add the needed formatting to the data in your field(s).

               In both options, be sure to clear the "do not replace existing value" check box.

               Both can produce identical results when browsing/printing/previewing the data, but you can get different results should you export or copy paste from FileMaker to a different application--so you may want to test both options to see what works best for your situation.