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

    Formatting text of names

    RichIves

      Title

      Formatting text of names

      Post

      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.

       

      Examples:

      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?