2007 Reports

[Arturo]

When I open a report in 2007 I would it to open maximized. Currently, it
opens in the corner with the banner and navigation pane present. How do I get
a full screen on open and still allow me to show my toolbars.

thank you.

 

[Gina Whipp]

Arturo,

You didn't mention how you were opening the report, so I assumed it is a
button. You can use this command...

DoCmd.Maximize

....with the button that you are using to open the report.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

When I open a report in 2007 I would it to open maximized. Currently, it
opens in the corner with the banner and navigation pane present. How do I
get
a full screen on open and still allow me to show my toolbars.

thank you.

 

[Paul Shapiro]

When I open a report in 2007 I would it to open maximized. Currently, it
opens in the corner with the banner and navigation pane present. How do I
get
a full screen on open and still allow me to show my toolbars.

I use VBA code in the event handlers for Report_Activate and deactivate:
Private Sub Report_Activate()
On Error Resume Next
DoCmd.Maximize 'Maximize the preview window
End Sub

Private Sub Report_Deactivate()
On Error Resume Next
DoCmd.Restore 'Restore normal window size
End Sub

This maximizes the report when it's the active window, and returns to normal
size when the report is not the active window.

 

[De Jager]

When I open a report in 2007 I would it to open maximized. Currently, it
opens in the corner with the banner and navigation pane present. How do I
get
a full screen on open and still allow me to show my toolbars.

thank you.

 

[Georges LAUFER]

When I open a report in 2007 I would it to open maximized. Currently, it
opens in the corner with the banner and navigation pane present. How do I
get
a full screen on open and still allow me to show my toolbars.

thank you.

 

[Jörn Bosse]

Hello,

you can use the following procedure:

Private Sub Report_Open(Cancel As Integer)
DoCmd.Maximize
End Sub

 

[Brian Griffey]

How about a macro... that opens the report... then maximizes the window.