Fix Microsoft Access RecordCount Displaying the Wrong Number
Question details
The user needs to correct the record count displayed in a Microsoft Access form caption, which initially shows an inaccurate total until a list box selection is made.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Navigating between records on an Access form using a synchronized list box.
- Observed behavior
- The form caption initially displays an incorrect record count (such as Record 1 of 1) upon loading, but updates to the correct total after selecting a different row in the list box.
Ensure you have a backup copy of your Microsoft Access database before modifying VBA code, form properties, or recordset behaviors.
Force the Recordset to Fully Populate Using VBA
Use the RecordsetClone property with MoveLast and MoveFirst methods to ensure Access counts all records accurately upon loading.
When an Access form loads with a synchronized list box, the recordset count may evaluate prematurely before all records are asynchronously loaded. Forcing the recordset to fully populate resolves the inaccurate 'Record 1 of 1' display.
Right-click your main form in the Navigation Pane and select 'Design View'.
Open the Property Sheet, navigate to the 'Event' tab, find the 'On Load' property, and click the ellipsis (...) to open the Code Builder.
In the VBA editor, insert the code `Me.RecordsetClone.MoveLast` followed by `Me.RecordsetClone.MoveFirst` to force Access to load the entire recordset into memory.
Ensure your custom label or form caption is set to read the `RecordCount` property from the now fully populated recordset (e.g., `Me.RecordsetClone.RecordCount`).

Use a Dedicated Selection Form
Replace the synchronized list box with a separate, dedicated selection form for more reliable navigation and accurate record counting.
Manage Data Effortlessly with WPS Office
While Microsoft Access handles complex relational databases, many everyday data tracking and list management tasks are easier and faster in a robust spreadsheet. WPS Office is a lightweight, free alternative to Microsoft Office that offers seamless format compatibility without a steep learning curve.
- 1. Download WPS Office: Visit the official WPS website to download and install the free, lightweight productivity suite.
- 2. Export Access Data: In Microsoft Access, export your tables or queries to Excel (.xlsx) or CSV format.
- 3. Open in WPS Spreadsheet: Open your exported data file in WPS Spreadsheet to quickly filter, sort, and track your records without form synchronization errors.

Frequently Asked Questions
Why does Microsoft Access show 'Record 1 of 1' when there are multiple records?
This occurs because Access loads records asynchronously to save time. When an element like a synchronized list box triggers the form to evaluate its RecordCount before the entire dataset finishes loading, it inaccurately displays the total as 1.
Does the FindFirst method in a list box cause the wrong count?
The FindFirst method itself navigates to a specific record and works correctly. The wrong count issue stems from the main form evaluating its recordset size prematurely when it first loads alongside the list box, rather than the FindFirst action itself.
Can I fix the RecordCount issue without writing VBA code?
Generally, forcing a full recordset evaluation requires a few lines of VBA code (such as MoveLast and MoveFirst). Alternatively, you can change your UI design to use a continuous form or a dedicated search form instead of a synchronized list box on a single form.




