Report Views...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When you open a form, how do you set it to automatically bring up a report
centered in a full page, with 150% Zoom? I use Access 2000.

Thanks!
 
I can't say for sure on 2000, but on 2003 there's an option "startup" under
the "tools" menu that let's you spedify what to open on startup.

CW
 
Heidelberg,

You can use a VBA procedure on the Open event of your form. I imagine
it might look something loke this...
DoCmd.OpenReport "NameOfYourReport"
DoCmd.Maximize
DoCmd.RunCommand acCmdZoom150
 
Hi Steve!

I used the following VBA:

Option Compare Database

Private Sub Report_Open(Cancel As Integer)

DoCmd.OpenReport "rptAllAssessmentsParameterBySchool"
DoCmd.Maximize
DoCmd.RunCommand acCmdZoom150

End Sub


However, I get a Run-time error 2585

This action can't be carried out while processing a form or report event.

What am I doing wrong?

Thanks for your help!
 
Hi Cheese whiz,

Thanks for thinking about me. I've seen the good work you did in other
messages. Do you know why I get an error message when I followed Steve's
suggestion?
 
Any more ideas on this?
I tried the code at "on open" in the report.
It maximized, but I get a message that says "The command or action Zoom 150%
isn't available now."
Funny, hehe.

A little tip.
Maximize on open and minimize on close on all my reports has taken away most
of my frustration regarding max/min with reports.

"Heidelberg" skrev:
 
Back
Top