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?