2007 Reports

  • Thread starter Thread starter Arturo
  • Start date Start date
A

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.
 
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.
 
Arturo said:
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.
Click to expand...

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.
 
Arturo said:
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.
Click to expand...
 
Arturo said:
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.
Click to expand...
 
Hello,

you can use the following procedure:

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