Function FindLabel ([LABELFIELD]) NewString = Replace([LABELFIELD],"&","&") FindLabel = "<ITA>" & NewString & "</ITA>" End Function
Function FindLabel ([PIN]) firsttwo = cint(left([PIN], 2)) block_qtrsec = cint(mid([PIN], 7, 3)) lot_parcel = mid([PIN], 10, 3) sub_acct = right([PIN], 2) if (firsttwo > 26 and firsttwo < 33) then block = "<CLR red='56' green='168' blue='0'>" & cstr(block_qtrsec) & "-" & "</CLR>" lot = "<CLR red='56' green='168' blue='0'>" & lot_parcel & "</CLR>" else block = "<CLR red='169' green='0' blue='230'>" & cstr(block_qtrsec) & "</CLR>" & " |" intLot = cint(lot_parcel) lot = "<CLR red='0' green='112' blue='255'>" & cstr(intLot) & "</CLR>" end if sublabel = "<CLR red='255' green='0' blue='0'>" & "-" & sub_acct & "</CLR>" FindLabel = block & lot & sublabel End Function
Hey,
Thanks for replying both of you, but as I mentioned, this is a text box not label annotation.
Label
Descriptive text based on one or more feature attributes. Labels are placed dynamically on or near features based on user-defined rules and in response to changes in the map display. Labels cannot be individually selected and modified by the user.
Annotation
Text or graphics that can be individually selected, positioned, and modified. Annotation may be manually entered or generated from labels. Annotation can be stored as features in a geodatabase or as map annotation in a data frame. There are two types of geodatabase annotation: standard annotation, which is not formally associated with features in the geodatabase, and feature-linked annotation, which is associated with a specific feature in another feature class through a relationship class.
Graphic text
Graphic text is useful for adding information on and around your map that exists in page space, as opposed to annotation, which is stored in geographic space. Dynamic text is a type of graphic text that, when placed on a map layout, will change dynamically based on the current properties of the map document, data frame, or Data Driven Page.