Others

Fix Microsoft Access RecordCount Displaying the Wrong Number

Aamir Naveed AkramAamir Naveed Akram Oct 28, 2026 868 views

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.
Before you start

Ensure you have a backup copy of your Microsoft Access database before modifying VBA code, form properties, or recordset behaviors.

Solution 1Recommended

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.

1
Open Form Design View

Right-click your main form in the Navigation Pane and select 'Design View'.

2
Access the Form_Load Event

Open the Property Sheet, navigate to the 'Event' tab, find the 'On Load' property, and click the ellipsis (...) to open the Code Builder.

3
Insert Recordset Navigation Code

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.

4
Update the Caption or Label

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`).

Force the Recordset to Fully Populate Using VBA
Performance Tip: Populating exceptionally large recordsets using MoveLast upon form load can impact performance. Ensure your underlying queries are properly indexed.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website to download and install the free, lightweight productivity suite.
  2. 2. Export Access Data: In Microsoft Access, export your tables or queries to Excel (.xlsx) or CSV format.
  3. 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.
Highly compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Lightweight installation ensures fast loading times on PC and mobile devices.Free and easy-to-use interface for efficient daily data management without complex VBA code.Built-in templates and advanced spreadsheet features to replace clunky database forms.
microsoft office alternative - wps office

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.