3 Replies Latest reply on Dec 15, 2009 10:16 AM by RichIves

    Formatting text of names



      Formatting text of names


      Is there a way to get names to format automatically when entering?


      I inherited a dB that has fields for first and last names. Sometimes the entry doesn't get capitalized correctly and I'm wondering if there's a way to fix it AND still maintain the automatic capitalization of the first letter. Field is set to Title Case.



      jones gets changed to Jones - this is OK.

      Jones-Smith  gets changed to Jones-smith - this is not OK.

      McBride gets changed to Mcbride - this is not OK.


      Manual changes won't "take".


      Is there a way to fix this?