Applies ToAccess for Microsoft 365 Access 2021 Access 2019 Access 2016

Applies to

Form Object

You can use the RecordSelectors property to specify whether a form displays record selectors in Form view. Read/write Boolean.

expression.RecordSelectors

expression Required. An expression that returns one of the objects in the Applies To list.

Remarks

The RecordSelectors property uses the following settings.

Setting

Visual Basic

Description

Yes

True

(Default) Each record has a record selector.

No

False

No record has a record selector.

Note: You can set this property by using the form's property sheet, a macro, or Visual Basic for Applications (VBA) code.

You can use this property to remove record selectors when you create or use a form as a custom dialog box or a palette. You can also use this property for forms whose DefaultView property is set to Single Form.

The record selector displays the unsaved record indicator when a record is being edited. When the RecordSelectors property is set to No and the RecordLocks property is set to Edited Record (record locking is "pessimistic" — only one person can edit a record at a time), there is no visual clue that the record is locked.

Example

The following example specifies that no record has a record selector in the "Employees" form.

Forms("Employees").RecordSelectors = False

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.