HELP!!! VIEWING REPORTS IN NORMAL WINDOW

C

Chris

I HAVE A FRONT END DATABASE WHERE I SETED UP THE FORMS TO MAXIMIZE AT OPEN.
THE PROBLEM IS THAT THE REPORTS ARE ALLWAYS OPENING IN THE SAME WAY
(MAXIMIZED), WHILE I NEED THEM IN A NORMAL WINDOW.
IF I MODYFY THE SIZE OF THE REPORT WINDOW, THE FORMS ARE DOING THE SAME
AUTOMATIC.
HOW CAN I SOLVE THIS PROBLEM?

I AM THANKING YOU FOR ANY HELP PROVIDED!!!
 
R

Rosco

Chris,
Try this.

In a module

Function OpenReport_Your_Report_Name()
DoCmd.OpenReport " Your_Report_Name",acPreview
DoCmd.Restore
End Function

Use the fuction to open the report

If your forms were set to open in normal mode, and you want the report to open maximized,
change the restoore command to:
DoCmd.Maximize

Hope this helps
Rosco

FYI - Please do not use all caps in your posts. It is considered impolite, and is difficult for some people to read.
Thanks
----- Chris wrote: -----

I HAVE A FRONT END DATABASE WHERE I SETED UP THE FORMS TO MAXIMIZE AT OPEN.
THE PROBLEM IS THAT THE REPORTS ARE ALLWAYS OPENING IN THE SAME WAY
(MAXIMIZED), WHILE I NEED THEM IN A NORMAL WINDOW.
IF I MODYFY THE SIZE OF THE REPORT WINDOW, THE FORMS ARE DOING THE SAME
AUTOMATIC.
HOW CAN I SOLVE THIS PROBLEM?

I AM THANKING YOU FOR ANY HELP PROVIDED!!!
 
J

John Vinson

I HAVE A FRONT END DATABASE WHERE I SETED UP THE FORMS TO MAXIMIZE AT OPEN.
THE PROBLEM IS THAT THE REPORTS ARE ALLWAYS OPENING IN THE SAME WAY
(MAXIMIZED), WHILE I NEED THEM IN A NORMAL WINDOW.
IF I MODYFY THE SIZE OF THE REPORT WINDOW, THE FORMS ARE DOING THE SAME
AUTOMATIC.
HOW CAN I SOLVE THIS PROBLEM?

I AM THANKING YOU FOR ANY HELP PROVIDED!!!
Click to expand...

First off... please lay off the CAPS LOCK KEY. It is hard to read and
looks like you are SHOUTING AT US. All lower case is preferable if you
have trouble with the shift key.

Maximizing any Access object automatically maximizes all of them. You
can put a little bit of VBA code in the Open event of a Form or Report
to maximize or restore the object:

Private Sub Form_Open(Cancel as Integer)
DoCmd.Maximize
End Sub

Private Sub Report_Open(Cancel as Integer)
DoCmd.Restore
End Sub
 
C

Chris

Thank you very much!
John Vinson said:
First off... please lay off the CAPS LOCK KEY. It is hard to read and
looks like you are SHOUTING AT US. All lower case is preferable if you
have trouble with the shift key.

Maximizing any Access object automatically maximizes all of them. You
can put a little bit of VBA code in the Open event of a Form or Report
to maximize or restore the object:

Private Sub Form_Open(Cancel as Integer)
DoCmd.Maximize
End Sub

Private Sub Report_Open(Cancel as Integer)
DoCmd.Restore
End Sub
Click to expand...
 
C

Chris

Thank you very much!
Rosco said:
Chris,
Try this.

In a module

Function OpenReport_Your_Report_Name()
DoCmd.OpenReport " Your_Report_Name",acPreview
DoCmd.Restore
End Function

Use the fuction to open the report

If your forms were set to open in normal mode, and you want the report to open maximized,
change the restoore command to:
DoCmd.Maximize

Hope this helps
Rosco

FYI - Please do not use all caps in your posts. It is considered impolite,
Click to expand...
and is difficult for some people to read.
 
Top