Printing

[expublish]

On my form the user has the option to print the record they are viewing. i know it is bad practice, but it actually prints the form - not a report.

At the moment the form is a little too wide to fit on one page but not vewry long. If I could change the printout view from Portrait to Landscape I am sure it would solve the problem. Does anyone know how to make it print in Landscape.

Just to confuse you a little more, the user selects the print option from a combo. The code for the whole combo (which also has other functions) looks like this:

Private Sub cboSelect_AfterUpdate()
Select Case Me.cboSelect.Value

Case 1
    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.PrintOut acSelection

Case 2
    DoCmd.GoToRecord , , acNewRec

Case 3
    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

Case 4
    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

End Select

End Sub

Thanks in advance,

Scott.

 

[scottfarcus]

Is this something that needs to be done on the fly? If not, go to design view of the form...Go to the File menu...Go to Page Setup...Change the Orientation to Landscape...save the form.