Map 3D: FDO Labels that skip empty values

In AutoCAD Map 3D, when a feature label’s data field is empty, the field value displays as <Null>.  For example, in a dataset of connected Waterbodies, the labels that use the name field may display <Null> if that field is blank.  This means that on-screen, the label will show the literal 'text'. 

To correct this, you can use a Conversion Function in the label expression.  In this Waterbodies example, the expression starts with the name field and uses the wtrtype field as a fallback whenever a <Null> value is encountered. 

Use the following expression: NullValue(name, wtrtype)

With this setup, waterbodies that have a name will display that value. If the name field is empty, the label will instead display the wtrtype value.

This approach ensures that your labels remain meaningful and visually consistent, even when certain fields contain NULL values.

I hope this helps you create more intuitive and informative labels for your maps in AutoCAD Map 3D!

About the Author

Civil Applications Expert<br><br>As an Applications Expert, Leo is responsible for supporting, training and implementation of software for survey and civil engineering professionals. He has more than 20 years of experience helping large and small, public and private clients in the eastern United States.

More Content by Leo Lavayen