ListBox.AllowValueListEdits property (Access)

Gets or sets whether the Edit List Items command is available when the user right-clicks a list box. Read/write Boolean.

Syntax

expression.AllowValueEditLists

expression A variable that represents a ListBox object.

Remarks

The AllowValueEditLists property determines whether the Edit List Items command is available when the user right-clicks a list box that's bound to a Lookup field.

If the Lookup field is bound to a list of values, the Edit List Items dialog box is displayed when the user chooses Edit List Items. The user can then add, delete, or edit the items to be displayed in the list box.

If the Lookup field is bound to a table or query, the form specified by the ListItemsEditForm property is displayed when the user chooses Edit List Items. The user can use the form to add, delete, or edit the items to be displayed in the list box.

The AllowValueEditLists property is not available for list boxes on a report.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.