Auto Formating Text Fields
Is there a way to auto format text that is entered on a form? Example... Say I have a form with fields First Name and Last Name The user then fills in First Name with "JOhN" and Last Name with...
Forum Discussion
I use the two fields and combine them into a [Full Name] field that formats it as needed.
Its a tricky formula, but here it is:
Upper(Left([First Name], 1))&""&Lower(Right([First Name], Length([First Name])-1)) &" "& Upper(Left([Last Name], 1))&""&Lower(Right([Last Name], Length([Last Name])-1))
I then only use the full name field in reports and all other places in the app, the first and last name fields are only used for the edit / add forms
Note: If they have 2 last Names, it will put the second last name in all lowercase.
Its a tricky formula, but here it is:
Upper(Left([First Name], 1))&""&Lower(Right([First Name], Length([First Name])-1)) &" "& Upper(Left([Last Name], 1))&""&Lower(Right([Last Name], Length([Last Name])-1))
I then only use the full name field in reports and all other places in the app, the first and last name fields are only used for the edit / add forms
Note: If they have 2 last Names, it will put the second last name in all lowercase.
Thanks for this formula! Have you subsequently figured out a way to get the first letter of the second last name capitalized, rather than in lowercase?
