7 Replies Latest reply on Apr 22, 2012 10:24 AM by m.bodily.consulting

    Changing to Title Case



      Changing to Title Case


      I am using FMP 11 Advanced and I have a field that is now restricted as a Lookup field.  However, before that happened, users would type information in the field that was all upper case, or all lower case, or some of both.  I would like to change the existing data in that field so that it shows Title Case and everything is now consistent.  How can I do that without scrolling through the 15,000 records and changing each one manually?  Thanks!