TextStyleAdd or Proper(self) to yield properly capitalized titles
I have a button that I have created that is supposed to replace the contents of the associated field (USUALLY ALLCAPS) to what I would call Title Case. I am looking for initial Caps on all of the words except "of, and, the (unless beginning of line), etc.
Proper gets me close. But then I need to figure out a way to go search for the "of, and, the" exceptions.
TextStyleAdd (self; Titlecase) seemed like it should be the answer but it is not doing anything.
Any thoughts on the right way to format my field with Title Case at the request of a button?