displaying the report full screen..

[Bosch]

Hello..

Only few hours ago I created my first report in access(2003), so my question most likely is very stupid..
I found the sample code somewhere and modified a little bit...
I have a list box that displays the report names and when I double click I want to view the report..

See my code below in the double click event of the list box:

stDocName = Reports_LB.Column(1, Reports_LB.ListIndex)
DoCmd.OpenReport stDocName, acViewPreview, , , acDialog

It displays the report..but not full size...I can read the report. I cannot maximize..When I click on the report it becomes readable but the size of the form on which it displays is the same...so I have to scroll back and forth to view any one page..

Is there a way I can see the report in a readable format?

I created the reports using Wizard.

Thanks

 

[godofhell]

Remove the acdialog so that it opens in default mode.

 

[ThreeCrow]

You could use in the OnOpen event property put this line of code

DoCmd.Maximize

and

in OnClose event property this line

DoCmd.restore

The first will open the report in full view
the second will close the report and restore your Form size.

Just another way of doing

 

[Bosch]

Thanks guys..DoCmd.Maximize and restore worked.
But when I tried removing the acDialog, the report was opened behind my current window also in the same minimized size..

Thanks again..