You are here: > ESRI Forums > arcgis desktop discussion forums > Thread Replies

ArcGIS Desktop Discussion Forums

ArcGIS Desktop - ArcObjects Visual Basic for Application (VBA) forum

Using field calculator to change field valu...   M Vwald Oct 29, 2003
Re: Using field calculator to change field...   Erik Nelson Oct 29, 2003
Re: Using field calculator to change field...   M Vwald Oct 29, 2003
Re: Using field calculator to change field...   RON BRUCE Jan 13, 2004
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Using field calculator to change field values to lower or "proper" case 
Author M Vwald 
Date Oct 29, 2003 
Message I'm trying to convert 1100 street names from all caps to lower or "proper" case (ie. CARTER RD to Carter Rd). I'm looking for help in using the field calculator to do this.
Thank you. 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Using field calculator to change field values to lower or "proper" case 
Author Erik Nelson 
Date Oct 29, 2003 
Message Try this, substitute your field into the brackets.

StrConv ( [YOUR FIELD],vbProperCase ) 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Using field calculator to change field values to lower or "proper" case 
Author M Vwald 
Date Oct 29, 2003 
Message perfect. you just saved me hours of typing. thanks so much. 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Using field calculator to change field values to lower or "proper" case 
Author RON BRUCE 
Date Jan 13, 2004 
Message Thank you for the script. You also svaed me many hours of typing.