How to not display NULL Values in a string label

Question

I have a feature class that I want to label based on three fields. It would be great if the first two fields always displayed, and the third only displayed when it isn't null. I have added all the field to a label no problem like this:

Is it possible to eliminate the word NULL in three of the five examples above?

NinaRihn · Answer

that is true, however the vb expression comes in handy if you would like to add characters or spaces between each value, like this:

Function FindLabel ([field 1], [field 2], [field 3])
If [field 3] <> " " then 
    FindLabel = [field 1] & "-" & [field 2] & "-" & [field 3] 
else
    FindLabel = [field 1] & "-" & [field 2]
end if
End Function

then the last dash doesn't show up if the last value is null

AbdullahAnter · Answer

If you have Null values in your field , it is automatically doesn't appear in label.

Just use simple expression: parser VBScript >

[Field1] & [Field2] &[Field3]

NinaRihn · Answer

you could add this vb expression:

Function FindLabel ([field 1], [field 2], [field 3])
If [field 3] <> " " then 
    FindLabel = [field 1] & " " & [field 2] & " " & [field 3] 
else
    FindLabel = [field 1] & " " & [field 2]
end if
End Function

this works for me even with Null values

exportimage1_viewresultstree.png

DRE.jpeg