2 Replies Latest reply on Jan 31, 2013 9:30 AM by RobertMoya

    How to make a DB in all upper case text

    RobertMoya

      Title

      How to make a DB in all upper case text

      Post

           Hi there,

           I have a DB with more than 3000 records and we would like to make all the text be upper case. Instead of going through each field, is there a faster way to acheive this?

           Thanks

        • 1. Re: How to make a DB in all upper case text
          philmodjunk

               That's odd. Most users find all upper case harder to read quickly and accurately. Sure that's a good idea?

               There are two ways to format text in your fields in FileMaker.

               You can apply the format to the Field object on a layout. If the text in the field is not formatted, this then causes the text to be displayed with the specified format.

               You can format the specific text in a specific field. (Such as selecting the text in a text field and using the text formatting bar to specify a text format.)

               With the latter option, you can use scripts with Replace Field Contents scritp steps to format your data all in one massive "batch update".

          • 2. Re: How to make a DB in all upper case text
            RobertMoya

                 Ya I understand what your saying about it being harder to read but thats how they want it. Anyways thanks for your input. It worked.