Fix an Access 2010 Report That Cannot Open in Layout View
Question details
Open or edit an Access 2010 report when Layout View is unavailable despite the Allow Layout View setting being enabled.

- Product
- Microsoft Access 2010
- Device & OS
- not provided
- Scenario
- The user wants to change a report, including header or footer text, while other reports in the database open normally in Layout View.
- Observed behavior
- Access says Layout View is unavailable for one report. Changing Allow Layout View has no effect, and the required header and footer text is not visible in Design View.
In the Navigation Pane, identify the affected report and confirm that other reports can open in Layout View. Note which header or footer text you need to change so you can look for it in the report sections.
Inspect and edit the report in Design View
Use Design View to check report settings and locate the controls that contain the text you need to change.
A report's design, record source, or legacy features may prevent Layout View from opening. Enabling Allow Layout View does not guarantee that every report can use it.
In the Navigation Pane, right-click the affected report and select Design View.
Press F4 to open the Property Sheet. Select Report from the selection list and check Allow Layout View on the Format tab. On the Data tab, review the Record Source to identify the table or query supplying the report.
In Design View, look for the Report Header, Report Footer, Page Header, and Page Footer sections. Select a section or its controls and use the Property Sheet to inspect their Visible and other relevant properties.
Look for labels or text boxes in the relevant section. Select a label to edit its Caption in the Property Sheet, or select a text box and inspect its Control Source to see where its displayed value comes from.
Save the report, then right-click it in the Navigation Pane and select Print Preview to check the changes.

Create spreadsheet-based reports with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with Office files. Export Access data to an Excel workbook to create a spreadsheet-based report in WPS; WPS does not fix Access Layout View or edit Access database reports.

Frequently Asked Questions
Why is Layout View unavailable when Allow Layout View is set to Yes?
The setting permits Layout View but does not guarantee that a particular report supports it. The report's design, record source, or legacy features may be involved. Open the report in Design View to inspect and edit it.
How do I open a report in Design View?
In the Access Navigation Pane, right-click the report and select Design View. Press F4 to display the Property Sheet.
Where can I find missing header or footer text?
In Design View, inspect the report and page header and footer sections. Select their labels or text boxes and check Caption or Control Source in the Property Sheet; the text may also come from an expression or report code.
Can WPS Office fix Layout View in Access?
No. Layout View is an Access feature, and WPS Office does not edit Access database reports. You can export data from Access to an Excel workbook and use WPS Spreadsheets to create a separate spreadsheet-based report.




