conditional labeling in ArcMap

[WinstonSastroredjo]

L.S.

I have an event which projects producing wells in Arcmap.
The fieldnames are: Wellname, Field, Xcoord, Ycoord, Latitude, Longitude, etc...
If I only want to display a certain well (e.g. from 29Nowugs04 to 29NOWUGS04) in full capital letters how should the label expression look like in VBScript?

Thanks in advanced.

Regards Winston Sastroredjo

[AnthonyGiles]

Winston,

try:

Function FindLabel ([Wellname])
  if ([Wellname] = '29Nowugs04') then
   FindLabel = UCase([Wellname])
  else
    FindLabel = [Wellname] 
  end if
End Function


Regards

Anthony

[WinstonSastroredjo]

Hey Anthony, I got an error

[ATTACH=CONFIG]18393[/ATTACH]

Any other deas?

Regards Winston

[JeffBarrette · Accepted solution]

Don't use single quote, use double quotes instead.

Function FindLabel ([Wellname])   if ([Wellname] = "29Nowugs04") then    FindLabel = UCase([Wellname])   else   FindLabel = [Wellname]   end if End Function

I get the same error if I use single quotes.

Jeff

[WinstonSastroredjo]

Thanks Jef

[AnthonyGiles]

Winston,

Glad you got it working sorry about the quotes, that will teach me for posting from my iPad

Regards

Anthony