Prev: Sequentially numbering records
Next: format single cell
From: Summing multiple fields on a form on 14 Apr 2010 01:58
On my form I put a Print Button. This button prints the current record only,
using an embedded macro. It works fine, except the record is printed in
portait. I need it to print landscape. What do I need to do to correct this?

Thanks
From: golfinray on 14 Apr 2010 08:45
Add this code to your print button OnClick event:
Dim vPrinter As Access.Printer
Set vPrinter = Application.Printer
vPrinter.Orientation = acPRORLandscape

--
Milton Purdy
ACCESS
State of Arkansas


"Summing multiple fields on a form" wrote:

> On my form I put a Print Button. This button prints the current record only,
> using an embedded macro. It works fine, except the record is printed in
> portait. I need it to print landscape. What do I need to do to correct this?
>
> Thanks
 | 
Pages: 1
Prev: Sequentially numbering records
Next: format single cell