REPORT PREVIEW - WINDOW NOT MAXIMISED 2

[harrisharris]

I have a number of reports that when opened, have two problems:
a. The report window is not maximised
b. Although I have selected Landscape in page setup, it sometimes reverts to portrait.

Is there a method to ensure the window, when the report is opened, is always maximised and landscape and amended margins are always displayed.

 

[randysmid]

Hi,
Microsoft wrote an FAQ on how to determine if a report (or form) is maximized or not, and shows a technique (Property Let statement) on how to maximize it if necessary.

http://support.microsoft.com/default.aspx?scid=kb;en-us;210190

HTH,
Randy Smith, MCP
California Teachers Association

 

[GingerR]

1) in the Report's OnOpen event, put

Docmd.Maximize

2) this has happened to me sometimes. i dont know why--it seems to be when i've changed the design of the report. i have to get into the habit of checking the Print Setup I guess. try just setting Landscape again, make sure you verify that after every time you alter the design, and i'm thinking it won't happen again. maybe someone knows some vba way?

g

 

[harrisharris]

Thanks Randy and Ginger. I tried Ginger's method first as it seemed the simplest and it works a treat.

Kind regards

Laurence

 

[tattie]

Regarding the problem of the page setup not retaining itself, I have experienced this same problem repeatedly when running Access 2000 on Windows 98 PC's. After installing Windows XP Professional on those same PC's, Access 2000 never again exhibited those problems with the page setup. That problem is now completely gone. What a relief!