Access Developer

Clive Beaton

<div>
Thanks Scott,<br />
<br />
I used the wrong terminology. &nbsp;I print the 'form' as a report.<br />
<br />
Looks like the second report for those users is the way to go.<br />
<br />
Clive
</div>


Thanks Scott,

I used the wrong terminology.  I print the 'form' as a report.

Looks like the second report for those users is the way to go.

Clive

<div>
<div class="content wysiwyg-content">
My application developed in Access 2010 produces 2 forms which fill most of the page, top to bottom and side to side. &nbsp;Most of my clients have no problem with this but I have 2 where the bottom of the form prints on a second page. &nbsp;I have Page Setup on a shortcut menu in which they can change the bottom margin but it doesn't stick.<br />
<br />
Is there a way to set the printer properties within my application in VBA?<br />
<br />
Thanks in advance.<br />
<br />
Clive
</div>
</div>


My application developed in Access 2010 produces 2 forms which fill most of the page, top to bottom and side to side.  Most of my clients have no problem with this but I have 2 where the bottom of the form prints on a second page.  I have Page Setup on a shortcut menu in which they can change the bottom margin but it doesn't stick.

Is there a way to set the printer properties within my application in VBA?

Thanks in advance.

Clive

Is there a way to set the printer properties within my application in VBA?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.