Jim,
Thanks, but that's not what I want.

This program is for children and everything must be as automatic as
possible.
There's a "Print" button on the form which I use to print the form.
At the moment I've got.

Sub PrintButton_Click()
Me.PrintForm
End Sub

That prints the form, but portrait style.
I need to adjust the code to make it print landscape.

Henry

"Jim Cone" wrote in message
...
Henry,

Show the form. Copy it using Alt+Prt Scrn keys.
Dismiss the form.
Paste into a blank Excel sheet. Print it the way you want.

Jim Cone
San Francisco, USA


"Henry" wrote in message
...
I've set up my form, filled it in, and now I want to print it.
Me.PrintForm does print the form but it prints portrait.
I want it printed landscape.
Any one know how to do it?
Henry