Formatting a Variable

[five_fingers]

Hello All,

Thanks for any suggestions you may have for my current problem.

I have two global fields that I'd like the user able to enter words in with or without capitalizing and then be able to specify a variable calculation using those global fields, but (and here's the catch) make the variable output Title Case.

Here's my attempt to set the variable's calculation using TextStyleAdd -

TextStyleAdd ( GlobalBlank1 & " " & GlobalBlank2 ; Titlecase )

With this calculation, I still get lower case words as a result if that's what's entered in the global field. Any suggestions?

Thanks again for any help,

Five Fingers

[comment]

Where do you "get lower case words as a result"?

[five_fingers]

In a custom dialog message based on a calculation using the variable. Does this make sense?

[comment]

Yes, it does. A custom dialog does not display styled text. But if you set a field to the variable, it WILL be styled.

Note that styling does NOT modify the text - it's merely attached to the text, and it will be removed where there is no support for styled text, e.g. during export to a text file or in a custom dialog. If you want a permanent modification of the text itself, use the Proper() function instead.

[five_fingers]

Terrific. That makes sense. I'll give the Proper() function a try. Thank you very much for your help.

FF

Edited June 20, 2008 by Guest