topic Re: Label Expression in Data Management Questions

Label Expression

CaraMays — Tue, 15 Jan 2013 19:49:20 GMT

Below is my current expression that is labeling landowner names, abbreviated to the first letter of their first name with a comma dividing the first initial with the last name.

I would like to add the PID directly below the name. I would like the PID to have the same label characteristics as the name or "PartyName" does.

Can anyone else where to add the PID and how to correctly format this. THANKS!

Function FindLabel ( [PartyName] )
if InStr( [PartyName] , ",") > 0 Then
myArray = Split( [PartyName] , ",")
FindLabel = myArray(0) & ", " & LEFT(Trim(myArray(1)), 1) & "."
ElseIf Len( [PartyName] ) > 13 Then
FindLabel = Left([PartyName], 13)
Else
FindLabel = [PartyName]
End If
End Function

Re: Label Expression

WadeLobb — Tue, 15 Jan 2013 20:31:57 GMT

Try

Function FindLabel ( [PartyName],[PID] )
if InStr( [PartyName] , ",") > 0 Then
myArray = Split( [PartyName] , ",")
FindLabel = myArray(0) & ", " & LEFT(Trim(myArray(1)), 1) & "."
ElseIf Len( [PartyName] ) > 13 Then
FindLabel = Left([PartyName], 13) & vbCrLf & [PID]
Else
FindLabel = [PartyName] & vbCrLf & [PID]
End If
End Function

Re: Label Expression

CaraMays — Tue, 15 Jan 2013 20:49:09 GMT

This only shows the landowner name. 😞 Thanks though! I will keep trying.