Required

Sets or returns a value that indicates whether a Field object requires a non-Null value.

Syntax

expression .Required

expression A variable that represents an Index object.

Remarks

Note

When you can set this property for either an Index object or a Field object, set it for the Field object. The validity of the property setting for a Field object is checked before that of an Index object.

The availability of the Required property depends on the object that contains the Fields collection, as shown in the following table.

If the Fields collection belongs to a	Then Required is
Index object	Not supported
QueryDef object	Read-only
Recordset object	Read-only
Relation object	Not supported
TableDef object	Read/write