August 28, 200322 yr Hope this is in the right fourm. I need to know how to make the first letter of a persons last name Capitalized along with there Middle Inital, and there first name. I have 3 sperate fields for the name "last name", "MI", "first name". Aslo if the have the cap locks on I only want to first inital capitalized and the rest of there name in lower case. Hope this isn't to complicated, and I hope i haven't babbled to much. Thanks
August 28, 200322 yr RE: Proper(fieldname) will do the trick. You can run that in script and replace old text in field with properly formatted text or show calculated fields with the above formula.
Create an account or sign in to comment