SaultDon

Label Expression to not label if...

Discussion created by SaultDon on Sep 29, 2010
Latest reply on Jul 14, 2011 by SaultDon
I am wondering how to get my label expression to not label a field if certain other fields are found.
Below is my expression.

Function FindLabel ( [LTSA_LOT] , [LTSA_BLOCK] , [LTSA_PA4] , [LTSA_PLAN] , [LAND_AC6] )
 if ( Len ([LTSA_LOT]) <> 0) then 
  str1 = [LTSA_LOT] & " - "
 end if
 if ( Len ( [LTSA_BLOCK] )  <> 0) then
  str2 =  [LTSA_BLOCK] & " - "
 end if
 if ( Len ( [LTSA_PA4] )  <> 0) then
  str3 =  [LTSA_PA4] & " - "
 end if
 if ( Len( [LTSA_PLAN] ) <> 0) then
  str4 =  [LTSA_PLAN]
end if
 if ( Len( [LAND_AC6] ) <> 0) then
  str5 =  [LAND_AC6]
end if
 FindLabel = str1 & str2 & str3 & str4 & VBNewLine & str5
End Function



I would like the label to not label Str5, if labels are found for str1-4.

Appreciate your time to help me with this.

Outcomes