2 Replies Latest reply on Jan 30, 2014 2:15 PM by tduell_1

    FileMaker Pro 13 TextFont Does Not Display Webdings

    tduell_1

      Summary

      FileMaker Pro 13 TextFont Does Not Display Webdings

      Product

      FileMaker Pro

      Version

      13

      Operating system version

      OS X 10.9

      Description of the issue

      TextFont function does not display Webding characters.

      Steps to reproduce the problem

      Create 2 calculation fields with the following code:

      TextFont ( "6" ; "Webdings")

      TextFont ( "4" ; "Webdings")

      Expected result

      TextFont ( "6" ; "Webdings") should display the down carrot.

      TextFont ( "4" ; "Webdings") should display the right carrot.

      Actual result

      TextFont ( "6" ; "Webdings") displays "6" in the default font.

      TextFont ( "4" ; "Webdings") displays "4" in the default font.

      Configuration information

      This works with FileMaker Pro 12, but not in the release of FileMaker 13. You also cannot place text on the layout and assign Webdings. It will still display the default text font instead of Webdings.

      Workaround

      None, not even a web viewer will display Webdings.

      Microsoft_Word1001.png

        • 1. Re: FileMaker Pro 13 TextFont Does Not Display Webdings

          tduell:

               Thank you for the post.

                

               This was previously reported in the following thread:

                

          Webdings

                

               In summary, this is a design change in FileMaker Pro 13. I've additionally added your research and comments to the report.

                

               TSFalcon

               FileMaker, Inc.

          • 2. Re: FileMaker Pro 13 TextFont Does Not Display Webdings
            tduell_1

                 What I'm finding is that the code relates more to the UTF-16 Decimal format when you are trying to figure out what number to use rather than the Unicode value.

                 For example: black-right_pointing triangle is UTF-16 decimal 9654

                 http://www.fileformat.info/info/unicode/char/25B6/index.htm

                 To get FileMaker to display the WebDing equivalent of "6" the formula is Char(Code(6)+9648-48). Follow the math:

                 Code(6) actually returns 6+48 = 54 because Code(0) = 48 Therefore, you have to subtract 48 from what ever value you want.

                 The code for the right triangle is 9654. Since we started with Code(6), we have to subtract 6 from the actual value to get what we want 9654-6=9648

                 To make is super simple, don't even use Code in the calc. Just use Char(9654) and you'll get the exact symbol. I know it's a pain, but it does seem to work as long as you can get the decimal value for the symbol you need.