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
