Can someone tell me if you can control the printing orientation (Portrait or Landscape) from Access 2000 or Access 2002.

I want one of my report to print in Landscape but sometime for no reason it prints out in Portrait layout?

Any help will be greatly appreciated

Thanks

You could have one printer already configured as Landscape as the default. Then you could send the Report, always selecting that specific printer.

Could also be the infamous report printing bug that resets your report formatting to the defaults when autocorrect is enabled.

See KB article:

http://support.microsoft.com/default...roduct=acc2000

Drove me nuts for a while. The fix is install current SRs.

Bob