Others

Highlight the Current Form Record in a Microsoft Access ListBox

Olivia MillerOlivia Miller Nov 22, 2026 868 views

Question details

Highlight the ListBox item that matches the current record on a Microsoft Access form.

Highlight the Current Form Record in a Microsoft Access ListBox
Product
Microsoft Access
Device & OS
not provided
Scenario
A form has a ListBox that should track the selected record as the user navigates between records.
Observed behavior
The ListBox should highlight the item whose bound-column value matches the current form record.
Before you start

Identify the ListBox control name and the form field whose value matches the ListBox's bound column. Check the ListBox's Property Sheet to confirm that Multi Select is set to None.

Solution 1Recommended

Update the ListBox in the form's On Current event

Use a VBA event procedure to select the matching ListBox item whenever the form moves to a record.

The form's Current event runs when the current record changes. Assigning the record's field value to an unbound ListBox selects the item with the matching bound-column value.

1
Open the form in Design View

In the Navigation Pane, right-click the form and select Design View. Select the ListBox and use its Property Sheet to check its Name, Bound Column, and Multi Select properties.

2
Open the Current event procedure

Select the form, open its Property Sheet, and choose the Event tab. In the On Current row, select [Event Procedure], then click the ellipsis button to open the VBA editor.

3
Assign the current record value

Inside the Form_Current procedure, add: Me!ListBoxName = Me!CustomerID. Replace ListBoxName with your ListBox control name and CustomerID with the form field that matches the ListBox's bound column.

4
Save and test the form

Save the form, open it in Form View, and use the record navigation buttons to move between records. Check that the matching ListBox item is highlighted.

Update the ListBox in the form's On Current event
Check for matching values: The ListBox row source must include the current record's value in its bound column. A Null value or a value absent from the list will not highlight a matching item.
Free Microsoft Office alternative

Work with tabular data in WPS Spreadsheets

For spreadsheet-based work, WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility to help you migrate existing files. It does not replace Access forms or fix their VBA event behavior.

View and organize tabular data in WPS SpreadsheetsOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar interface for everyday spreadsheet tasksMove existing Office documents into a lightweight, free suite
microsoft office alternative - wps office

Frequently Asked Questions

Where do I add the code for the form's Current event?

Open the form in Design View, select the form, and open the Property Sheet. On the Event tab, set On Current to [Event Procedure] and click the ellipsis button.

Why doesn't the ListBox highlight an item?

Check that the current record's field value exists in the ListBox row source and matches its bound column. Also check that Multi Select is set to None and that the control and field names in the code are correct.

Does the ListBox need to be bound to a form field?

No. An unbound ListBox can display the current record's selection without writing the selection to a form field. Check its Control Source on the Property Sheet.

Can WPS Office run this Access form event?

No. The On Current event and its VBA code are Microsoft Access features. WPS Spreadsheets can work with spreadsheet data but does not run Access forms.