Access 2007 Layout View for reports upgraded from Access 2003

[Mr. Benjamin Strauss]

I notice that in Access 2007 only those reports newly created in
Access 2007 appear to have access to Layout View. In an ACCDB that had
been converted from an Access 2003 MDB the reports that had originally
been created in Access 2003 do not have access to this feature. Any
attempt to do so is met with a "Layout view is unavailable for this
Report." message.
Is there any way, short of recreating the report and manually copying
over its controls and code, to upgrade such reports so that Layout
View is accessible?

 

[Jeff Conrad [MSFT]]

Hi Benjamin,

1. Open the report in design view
2. Open the property sheet (the button is in the Tools group on the Design
tab in the Ribbon)
3. Make sure you select the report so you're looking at the report
properties
4. On the Format or All tabs of the Property Sheet, look for an option
called "Allow Layout View"
5. Change that from No to Yes
6. Save and close the report

You should be able to open it in Layout View now.

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com