My Microsoft ACCESS report

Ann Fishkin 20 Reputation points
2026-10-15T18:34:09.9566667+00:00

My Microsoft ACCESS report does not display data when print preview is selected

Microsoft 365 and Office | Access | For home | Windows
0 comments
Answer accepted by question author
Hani-Ng 2,490 Reputation points Independent Advisor
2026-10-15T19:00:18.87+00:00

Hi Ann Fishkin

You can refer to AI's response first, especially regarding filters, criteria, and the report's record source.

Additionally, it may be worth checking whether the issue is related to the report design itself. For example, if the report contains custom formatting, VBA code, or specific control properties (such as Visible, Can Grow, or Hide Duplicates), the data may appear differently in Print Preview than in other views.

As a quick test, try creating a new report using the same data source. If the new report displays the data correctly in Print Preview, this may indicate that the issue is related to the original report's design rather than the underlying data.

You could also try running Compact & Repair Database in Access (File > Info > Compact & Repair Database) and then test the report again. This built-in Access feature can help resolve certain database-related issues.

If the issue persists, please let me know whether the report displays data correctly in Report View and whether all fields or only specific fields are missing in Print Preview.

I hope this information helps and look forward to your update.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest

  1. AI answer

    2026-10-15T18:34:25.6966667+00:00

    Common causes for an Access report showing no data in Print Preview are:

    1. A permanent filter was saved into the report design
      • This happens when a report is first saved while a filter is active.
      • Result: the report continues to show only the filtered records, and the filter cannot be turned off normally.
      • Fix:
        1. In the Navigation Pane, right-click the report and select Design View.
        2. If the property sheet is not visible, press F4.
        3. Click the report’s Record Source property, then click the Builder button.
        4. In the query design grid, look for filtered fields and criteria.
        5. Select each filtered column and press DELETE.
        6. Close the query designer and click Yes to save the SQL changes.
    2. The report has no records to display
      • Access can open or preview a report with no records unless logic was added to stop it.
      • If a macro or VBA code was added to the report’s On No Data event, the report can cancel opening or printing when no data is returned.
      • Check whether the report’s record source currently returns records.
      • Also check whether the report has an On No Data event procedure that cancels the report.
    3. The report criteria or filter does not match any data
      • If the report is filtered, or its underlying query criteria exclude the expected rows, Print Preview will show no data.
      • Review the report filter and the query behind the report to confirm the expected records are included.

    If the issue started after saving a filtered report, the most likely fix is removing the saved filter from the Record Source.

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.