HELP!!! VIEWING REPORTS IN NORMAL WINDOW

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

What are you asking?
Fons
-----Original Message-----
There is no message with ID specified in this newsgroup

On Wed, 19 May 2004 09:56:30 +0300, "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!!!


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


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Thank you very much!
"John Vinson" wrote in message
...
On Wed, 19 May 2004 09:56:30 +0300, "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!!!


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


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public