How do I turn off labels that have null values?

I am using a leader with this label but I want it turned off if the values are null

2 Answers 2


you can add a query filter to which labels will be rendered.

http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=About_labeling http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=Displaying_labels

Check the section "Controlling which features are labelled".

Essentially, you will add a query to the label manager, something like this

[Attribute_being_labbeled] is not null

And then, nulls won't be rendered.


If you go to the layer properties label tab, select the Method drop down that says:

define classes of features and label classes differently

you will see a box appear reading "SQL Query..."

If you then enter:

 "Field of your choice" <> 'Unique value of your choice'

So, say the field is ROAD NAME and the unique road name you do not want to be visible is NULL

You will enter:


Same thing as the former example, but redundancy sometimes helps. That will to it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.