null field

A field containing no characters or values. A null field isn't the same as a zero-length string ("") or a field with a value of 0. A field is set to null when the content of the field is unknown. For example, a Date Completed field in a task table would be left null until a task is completed.