[AccessD] Page Orientation 2003

Isn't this the famous bug that concerns the setting of the AutoCorrect
Spellcheck thing?

On 7/27/07, Tony Septav <iggy at nanaimo.ark.com> wrote:
>
> Hey Michael
> Thanks
> No error messages.
> I think it has to be a printer problem or
> I am missing a turn off/turn on setting in Access2003.
>
> If I set the printer (Dell Photo Printer 720) preferences, to letter 8
> 1/2 by 11, portrait.
> Then go into the design mode for a report (in Access98) that was set to
> letter and landscape, select page setup the orientaion is set to
> portrait and if I click landscape then  exit (and don't do anything) and
> go back in,  it is back to portrait and vice a versa if I set
> preferences to landscape and open a report that was set to portrait.
>
> I tried the code below for 2003, I downloaded from Microsoft, but it
> doesn't fire off the orientation setting  still stays as portrait.
>
>    Dim rpt As Access.Report
>    Dim prtr As Access.Printer
>
>    Set Application.Printer = Nothing
>    Set prtr = Application.Printer
>
>    'Set the default printer's orientation to landscape
>    prtr.Orientation = acPRORLandscape
>
>    'Set the default printer's paper size to legal
>    prtr.PaperSize = acPRPSLegal
>
>    'Print Preview the Client Report
>    DoCmd.OpenReport "client", acPreview
>    Set rpt = Reports("client")
>
>    'Set the Printer property of the report to the
>    'Application.Printer object
>    Set rpt.Printer = prtr
>
>    'Uncomment the following line if you wish to save the object
>    'with the current settings
>    'DoCmd.Save acReport, "Client"
>
> I hope I have not pulled off a "bonehead" manuever in my upgrading.
>
> Thanks Again
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>