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