7 replies to this topic

[ELeFevre]

Does anyone know the function (or have a VB script) for changing all uppercase text, i.e "COLORADO" to "Colorado" in ArcMap. I can't find it in the ArcMap Help.

[benbakelaar]

Does anyone know the function (or have a VB script) for changing all uppercase text, i.e "COLORADO" to "Colorado" in ArcMap. I can't find it in the ArcMap Help.

<{POST_SNAPBACK}>

Here's a thread about changing your attribute table cells...
http://forums.esri.c...&t=98549#275079

but I think you are referring to user-added text boxes?

[ELeFevre]

Thanks for the link, Ben. I'll check out the tips and let you know how it works out.

"User added text boxes"...I'm not sure I understand?

Basically I have a column with 1,600 records, all upper-case and most of the attributes are comprised of two or more words, i.e, SALT LAKE CITY. E

[ELeFevre]

This works:

StrConv ( [YOUR FIELD],vbProperCase )

[benbakelaar]

"User added text boxes"...I'm not sure I understand?

<{POST_SNAPBACK}>

Since you didn't say "text from a table" I thought you might mean like work you had done in layout view, like hand labeling places. I guess that's mostly the non-Esri people who end up needing to do that, for whatever reason.

[MapMedia]

You don't need a script - there is an option in text proporties (not sure which tab as I am remote from workstation) - but it gives you options Sentence case, lower, upper, super, etc.

Nice for working with databases that are all caps.

Chris

[ELeFevre]

Chris,
Even though the script I posted did the trick, it would great if I could do it as you have suggested. Would you mind posting a little more info on how to do this when you get the chance? Erin.

[mike]

You don't need a script - there is an option in text proporties (not sure which tab as I am remote from workstation) - but it gives you options Sentence case, lower, upper, super, etc.

Nice for working with databases that are all caps.

Chris

<{POST_SNAPBACK}>

You're right, there is a text option to change caps, but that only works to convert to All Caps or Small Caps or normal. so if you had all lower case, you can change to all caps or small caps. but if your original text is all caps already, there is no option to change to initial caps unfortunately. However, the script posted above works great.