How to Fix Duplicate Records Displayed in Access Continuous Forms
Question details
The user needs to resolve an issue where an Access continuous form displays duplicate lines after a runtime upgrade, despite there being no actual duplicate records in the database.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Viewing data in a continuous form after upgrading the Microsoft Access runtime from 2016 to 2022.
- Observed behavior
- The continuous form occasionally displays duplicate lines. These apparent duplicates are not stored in the underlying database and may temporarily disappear when the Access file is reopened.
Before troubleshooting, confirm whether the duplicate lines still appear immediately after completely closing and reopening the Microsoft Access application, as this helps distinguish between a persistent SQL query issue and a temporary rendering glitch.
Verify the Form's Record Source Query
Determine whether the issue is caused by a flawed SQL query returning actual duplicate records or if it is purely a visual rendering artifact in the continuous form.
Continuous forms rely on an underlying Record Source to display data. If the runtime upgrade altered how certain table joins are processed, the query might now return duplicate rows. Alternatively, the new runtime might simply be experiencing a visual rendering bug.
Right-click your continuous form in the navigation pane and select 'Design View' to access the form's structural properties.
Press F4 to open the Property Sheet, navigate to the 'Data' tab, and find the 'Record Source' property, which will contain either a table name, a query name, or an SQL statement.
Click the ellipsis (...) button next to the Record Source field to open the Query Builder, then click 'Run' (the red exclamation mark) in the ribbon to view the raw datasheet.
Look closely at the datasheet results. If duplicates appear here, you must adjust your SQL query (e.g., by adding a DISTINCT clause). If the datasheet shows no duplicates, the issue is a visual artifact specific to the continuous form layout in the 2022 runtime.

Looking for a Lighter Alternative for Your Data Management?
While Microsoft Access is a powerful relational database tool, it can sometimes suffer from complex runtime conflicts and rendering issues. For many data tracking, filtering, and reporting tasks, a robust spreadsheet solution is faster and more reliable. WPS Office provides a free, lightweight alternative that handles large datasets with ease.

Frequently Asked Questions
Why do duplicate lines disappear when I reopen the Access file?
This behavior typically indicates a memory caching issue or a visual rendering bug introduced in the newer Access runtime, rather than actual data duplication in your underlying database tables.
How do I remove duplicate records from an Access query?
You can eliminate duplicates by switching your query to SQL View and typing the word 'DISTINCT' immediately after the 'SELECT' keyword. This forces the database engine to return only unique rows.
Can a corrupted continuous form cause display issues after an upgrade?
Yes, form metadata can sometimes become corrupted during a version or runtime upgrade. Creating a new continuous form and binding it to the same record source often bypasses these stubborn rendering issues.




