Full-size Preview? (AXP 10.2627.2625)

Topic

New Reply

Is there an argument to OpenReport (or perhaps some other function) that would allow me to specify that a report opened in ‘preview’ would display at full size, rather than ‘full page’ view?

Reply | Quote

Replies

In the On Open Event of the report :
DoCmd.Maximize

Reply | Quote

Merci!

Reply | Quote

Maximize enlarges the entire window.

What I _really_ want is the same size window, but full size display _in_ that window. As if I had applied the zoom mouse-pointer.

Reply | Quote

Include the following line after your DoCmd.OpenReport statement:

DoCmd.RunCommand acCmdZoom100

Note that this will not work if you try to include it in your On Open event for the report. Docmd.Maximize does work either place… go figure.

Reply | Quote

Thanks Tom, but I was too cocky, thinking I knew where these commands go

The CmdButton on my form runs a macro that displays the PrintPreview for the report.

Where do i write the two statements to execute sequentially so that the form is zoomed?

Reply | Quote

Peter,

If you’re using a macro for the On Click event for your Preview Report button on your form, then you just need to add a second action to that macro (after your OpenReport action). Select RunCommand as the action and Zoom100% as the command (it’s in the command drop-down list).

Alternatively, if you’re using VBA code (by selecting “Event Procedure”) as the On Click event handler, then include the following code for your cmdButton_Click() procedure:

DoCmd.OpenReport “ReportName”, acViewPreview
DoCmd.RunCommand acCmdZoom100

Hope this helps. Holler if you need more detail.

Reply | Quote

Thanks –

I got it to work by using the event procedure, and will probably stick with that in the future.

Reply | Quote

You may want to place the DoCmd.Maximize stmt right after your DoCmd.OpenReport. Then you don’t have to put code in the report.

Reply | Quote

Thanks!

Reply | Quote