Print a form in landscape

[philbennison]

Hi all,

I have an excel spreadsheet, when a macro is run it opens a form and produces a list of random items. When a command button is pressed, it prints out the form
The problem is that it prints in potrait. How do i get it to print in landscape every time ??
I read on this forum that you go into the form design mode, click file and page setup but this does not appear on my list

Please help !!!!!

The code to print is

Private Sub CommandButton1_Click()
PrintForm
End Sub

Phil

 

[Rich]

Forms aren't designed with printing in mind, use a Report instead

 

[philbennison]

how do i use a report

sorry, i have never used a report, is it easy to change the details in a form to a report ??

Thanks in advance

 

[Rich]

There is a Save as Report option on the toolbar, one or two minor adjustments and hey presto, just change the code on your button to open the report

 

[godofhell]

The other way to save the form as a report is simply open a new blank report, copy and paste all the fields in the form to the report, change the report datasource to the query you want to use and you will get the same look of the form in a report.

 

[philbennison]

There is no 'save as report' in my toolbar, This is excel, should there be one ???

 

[Pat Hartman]

This is an Access forum. You are getting solutions that apply to Access. You will do better if you place your question in an Excel forum.