Labeling in ArcGIS using VBA - Teach Me GIS .com

1 Labeling in ArcGIS using VBA 1 of 2 Labeling in ArcGIS using VBA Your labels in ArcGIS can be greatly enhanced with the help of some HTML formatting tags. In order to take advantage of these tags, you must build an Expression, which can be done with the Expression builder in the Labels tab of your Layer Properties window. using the Expression builder, you can formulate labels that look exactly how you want them to look, with the help of VBA and HTML (for more help with HTML, please see our Labeling in ArcGIS with HTML document). Labeling in ArcGIS using VBA 2 of 2 Below is a chart of some useful VBA constants and functions you may need when creating labels in ArcGIS . Useful VBA Constants and Functions: & - Used to concatenate strings VBCRLF or VBNewLine Inserts a carriage return into the label sometext Prints the literal text you specify between the quotation marks MID (string, start,length) Extracts a substring from a column UCASE(string) Converts a string to upper case LCASE(string) Converts a string to lower case REPLACE(string, old , new ) Replaces each occurrence of old with new in the string.

2 Can be used to replace spaces with a carriage return: REPLACE (string, ,vbcrlf) FORMATNUMBER(string,0,0,0,-1) the first 0 says 0 decimal places. The second 0 specifies whether or not to include a leading zero for fractional values. The third 0 specifies whether or not to place negative values within parenthesis. The 1 is a flag to say that the numbers should be grouped ( use commas to make the number more readable). In the last 3 cases (all except the number of decimal places, obviously), 0 means false and -1 means true. Note that there is an easier way to do this particular task! Check the Layer Properties/Fields tab, the FORMAT button!