Datareport is causing me a heart attack!

[guyjasper]

you may want to set printer orientation through code. take a look at the link.

[Bombdrop]

You can change the Orientation by uising the code below it requires you to have service pack 4 or above ( Vb last service pack was 6 and i sugest you download it).

Option Explicit

Private Sub Command1_Click()
DataReport1.Orientation = rptOrientLandscape
DataReport1.Show
End Sub

Hope this helped!!

[Hack]

Moved to Reporting section