preview window size

[Colin Hammond]

I have just changed to Access 2003. My 97 database translated successfully
but the following disadvantages have appeared.
The print preview window is too small to give the operator the confidence
that he is printing the correct page, or to view data without printing or
making the page full screen.
Also I have to click three buttons to open the database. All to do with the
fact that there is code in the database and whether I want to run it or not.
Any way of overcoming these features which will be more of a problem to the
uninitiated operator than the irritation it causes me.
Colin

 

[Guest]

For reports I use the function below.

Public Function fMoveSize()
On Error GoTo Err_fMoveSize
DoCmd.MoveSize 1, 1, 14500, 9000
End Function

Then in the On Open event of each report I put in the following code:
Private Sub Report_Open(Cancel As Integer)
fMoveSize
End Sub

Depending on the screen resolution, you may have to play around with the
14500 and 9000 to get the correct size for the monitor.