How do I change the size of the preview report popup box?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I code an event to Preview Report, I want the report to display full
screen, not a partial screen. How do I do this?
 
When I code an event to Preview Report, I want the report to display full
screen, not a partial screen. How do I do this?
Click to expand...

Don't know what you mean by 'full screen' or 'partial screen'.
Any way, one of these runcommand's or Maximize is probably what you
are looking for.

In the event used to open the report:

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.Maximize
DoCmd.RunCommand acCmdZoom100
or...
DoCmd.RunCommand acCmdFitToWindow

Look up the other various Zoom sizes available in VBA Help.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing print preview after printing 8
using unbound popup form for parameters 1
Capture Print Event from a Report Preview 1
Form, instead of Report, Prints ??? 0
Excel VBA - Problem with Closing Print Preview 0
access report 0
Access Access Report Works on One Machine but not Another 3
Access 2007-Report opens by default in Print Preview mode 2

Back
Top