Report Views...

H

Heidelberg

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!
 
C

Cheese_whiz

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
 
S

Steve Schapel

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
 
H

Heidelberg

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!
 
H

Heidelberg

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?
 
C

Claes D

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:
 
H

Heidelberg

Thanks for the tip...

It can get frustrating at times.

Did you get a Error Run-time 2585?
 
Top