Link to home
Start Free TrialLog in
Avatar of LillyC
LillyCFlag for United Kingdom of Great Britain and Northern Ireland

asked on

How to capitalize each work in a field

Could you please let me know if and how I can set a field to capitalize each work, preferably without using code?

Thank you.
Avatar of zzynx
zzynx
Flag of Belgium image

You probably mean capitalize each worD?
Avatar of LillyC

ASKER

Yes sorry each WorD :)
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Do you want the entire word capitalized or do you want just the first letter? Also will the field contain multiple words?
Avatar of LillyC

ASKER

Just the first letter capitalized and yes the field could contain multiple words.
To capitalize just the first letter of the first word then you could use
>@< as the fields format.  If you need the first letter of every word then you would need to format it via a function when the field is updated or when you display it.
Avatar of LillyC

ASKER

I have tried to put >@< in the fields format but it changes to ><@ and doesn't capitalize the first letter?
Yeah, I just tried it myself.  Not sure when they changed it.
Avatar of LillyC

ASKER

Thank you