1 Reply Latest reply on Sep 6, 2013 7:19 AM by philmodjunk

    Size formatting



      Size formatting


           Is there anyway to format text that is going to be pasted in a record from excel? For example, if a value is copied from excel to filemaker and the size is 8 pt in excel it changes it to 3 pt in filemaker.  The field i am pasting into is formatted for 18 pt font, but it does not change the inserted text.

           Any help would be greatly appreciated


        • 1. Re: Size formatting

               THe data pastes with formatting tags from the original application. These supersede formats specified in layout mode for the field.

               Add this auto-enter calc to strip out all such formatting:

               TextFormatRemove ( self )

               and clear the "do not replace existing value..." check box.

               Then you font size specified for the field will be the only formatting left and it will control the size of your data.