Edit

Share via

Index.Required property (DAO)

  • Article

Applies to: Access 2013, Office 2013

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