Open report in full view?

R

Rick

I have some reports that I made, when I open them they
show up on the screen but the window is small. Then to
view the whole page I have to drag and resize the window.
I tried to open in design view and adjust window then
save but this dosen't work. How do I set it so they open
the full size of screen?

Thanks Rick
 
S

SA

Rick:

Add to the On Open event of your report:

Docmd.Maximize

In the code that opens the report, do something like:

Docmd.OpenReport "MyReport", acViewPreview
Docmd.RunCommand acCmdZoom100
 
R

Rick

Thanks, the Docmd.Maximize works which opens the report
full screen but I can't get the other part to work. The
report still goes to fit screen and won't go to 100%
view. I did put Report_rndquestion where you have
MyReport in code but still get errors, ANY HELP ANYONE?
Thanks again
Rick
 
S

SA

rick:

You can also move the docmd.maximize outside the report as in:

Docmd.OpenReport "MyReport", acViewPreview
Docmd.RunCommand acCmdZoom100
Docmd.SelectObject acReport, "MyReport"
Docmd.Maximize
 
C

Connie

Rick if you are using Access XP (I'm not sure if this property is in the
prev versions) there is a AutoSize for reports. If set to Yes it will
display report to fit entire page.... set this to No & it should work.
Also, I believe, you can eliminate that line of code that sets it to 100%,
by just changing this property to No.

hth
Connie
 
C

Connie

BTW, you'll find that property on the Format Tab of the properties window
(just in case you were not aware of that) ;)
 
Top