AnsweredAssumed Answered

Formatting text of names

Question asked by RichIves on Dec 15, 2009
Latest reply on Dec 15, 2009 by 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?

Outcomes