English

FAQ: Is it possible to assign nulls to a field using the Field Calculator?

Question

Is it possible to assign nulls to a field using the Field Calculator?

Answer

Yes, it is possible to assign nulls to a field using Field Calculator. However, assigning a null to a field is only supported for data stored in a geodatabase and when the field is nullable. In addition, null records are not supported for fields in a database file format (.dbf), even if the data is stored in a geodatabase.

Instructions provided describe how to assign nulls to a field.

  1. Load the desired data into ArcMap.
  2. Right-click the desired layer and select Edit Features > Start Editing.
[O-Image]
  1. Right-click the desired layer and click Open Attribute Table.
  2. In the attribute table, right-click the desired field and select Field Calculator.
[O-Image]
  1. Select Python as the Parser.
[O-Image]
  1. Type None in the expression box.
  2. Click OK.
[O-Image]
Note:
Values can also be set to Null using the VB Script Parser. When using VB Script, instead of entering None, enter Null in the expression box.
Note:
For the above steps to work, the field being calculated must allow null values. When creating a new field, the Allow NULL values option must be set to Yes.  
[O-Image]

Related Information

Last Published: 12/16/2016

Article ID: 000012852

Software: ArcGIS for Desktop Advanced 10.4, 10.3.1, 10.3, 10.2.2, 10.2.1, 10.2, 10.1 ArcGIS for Desktop Basic 10.4, 10.3.1, 10.3, 10.2.2, 10.2.1, 10.2, 10.1 ArcGIS for Desktop Standard 10.4, 10.3.1, 10.3, 10.2.2, 10.2.1, 10.2, 10.1 ArcMap 10.4.1, 10.4