Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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

share|improve this question

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.

share|improve this answer

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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