Office Performance Issues

How to Fix Duplicate Records Displayed in Access Continuous Forms

Khadija KhanKhadija Khan Oct 22, 2026 869 views

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.

How to Fix Duplicate Records Displayed in Access Continuous Forms
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 you start

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.

Solution 1Recommended

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.

1
Open Form Design View

Right-click your continuous form in the navigation pane and select 'Design View' to access the form's structural properties.

2
Locate the Record Source

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.

3
Run the Query Directly

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.

4
Inspect for Duplicates

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.

Verify the Form's Record Source Query
Resolving Visual Artifacts: If the query is functioning correctly and the problem is purely visual, try recreating the continuous form from scratch or adjusting the Detail section's height properties to force the runtime engine to render the lines correctly.
Free Microsoft Office alternative

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.

Seamless compatibility with Microsoft Excel (.xlsx) formats ensures your exported data opens flawlessly.Lightweight architecture runs smoothly without complex runtime dependencies or version conflicts.Familiar interface allows you to organize, filter, and analyze records effortlessly without SQL knowledge.Completely free to use, featuring advanced pivot tables and data visualization tools.
microsoft office alternative - wps office

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.