printing a form

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Is there any way to print a form, not all of which is
visible on the screen?

Thanks...
 
Hi, Matt

I use the PrintForm Method extensively
to print forms that are much deeper than
what's seen on the screen. The PrintForm
method prints only visible objects, so the secret is to issue a temporary Zoom
so that everything fits on the screen, then print the form, and then resore the
form size; that is,

UserForm1.Zoom = xx
UserForm1.PrintForm
UserForm1.Zoom =100

where xx is some 2-digit number that
you've assigned so the form and all
its objects fit on the screen. If the print
buffer is large enough, the process goes
fast enough that users do not see the
form shrink to fit before being restored
to its normal size.

-- Dennis Eisen
 
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

Excel VBA - Problem with Closing Print Preview 0
Set certain cells to print and others not to print 2
Cell invisible when printed. 1
Epson XP-3150 not printing 2
Print visible rows only 3
after print 2
Frame captions aren't printing when the userform is printed 2
Print Range 1

Back
Top