Preview Form Window?

[AC5FF]

When I open up a form the window that opens is always sized too small. If the form I am working on is full screen then the report opens full screen - that's just not a real option here.

Is there a way in the code to tell it to automatically open as full screen?

Private Sub Command8_Click()
On Error GoTo Err_Command8_Click

    Dim stDocName As String

    stDocName = "CGAS ADDRESS REGISTER (defined)"
    DoCmd.OpenReport stDocName, acPreview

Exit_Command8_Click:
    Exit Sub

Thanks!

 

[boblarson]

You can use this in the On Open event of the report:

DoCmd.Maximize

and then in the On Close event of the report

DoCmd.Restore

 

[AC5FF]

Thanks Bob

The maximize command worked, but I put the restore in the wrong location and the net effect was no change.
But I got it working.. Thx!