Report Orientation Problem

echovue · January 10th, 2005, 07:04 PM

I have several application written in Access 2003 that create reports dynamically to print out. They worked fine last week, but now when the report is previewed the page is shown as landscape, even though it still prints with a Portrait orientation. I am pulling what is left of my hair out trying to figure it out. Has anyone seen anything similar, or know what could cause this?

An extract of the creation code is...

Private Sub PrintLetter()
    Dim printReport As Report
    Dim ctrlLogo As Control
    ...

    Set printReport = CreateReport()
    printReport.Printer.TopMargin = 720
    printReport.Printer.BottomMargin = 1440
    printReport.Printer.LeftMargin = 1440
    printReport.Printer.RightMargin = 1440
    printReport.Printer.Orientation = acAPRORPortrait

    Set ctrlLogo = CreateReportControl(printReport.Name,
    acImage, , , , 3260, 0, 2840, 940)
    ...

Thanks in advance

Mike

Mike
EchoVue.com

echovue · January 11th, 2005, 01:35 PM

Sorry to bother everyone. The problem was that despite setting the Orientation to Portrait, my default printer somehow got set to use landscape as the default orientation and this was overinding any VBA code that I had in place.

I am now bald and feeling kind of sheepish!

Mike
EchoVue.com