Re: Open report in full view?

  • Thread starter Thread starter Rick
  • Start date Start date
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
 
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
 
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
 
BTW, you'll find that property on the Format Tab of the properties window
(just in case you were not aware of that) ;)
 
Open Report in full view

Thanks, Connie.

The Report / Properties / Format / AutoResize No
routine has saved my bacon.

Much appreciated.:)
 
Back
Top