We beget seen in the earlier Article how to alteration Paper Size and Page Orientation of MS-Access Reports automatically completely program during any Printer on the Network. notably We beget copied PrtDevMode Property Values into Memory; modified them to fraternity the Paper Size and Page Orientation of the Report and updated them controvert into the Report Page Settings on the vigil of printing it on the black distinguish oneself Printer installed on the User’s Machine. We are affluent to effect a compare favourably with warm-up to alteration the Margin Settings of MS-Access Report completely program. The operation is about at any rate as of the aforementioned representation.
This time again we beget to handiwork with PrtMip Property of the Report to alteration the Margin Values. notably The steps entranced in the Program is as follows:Open the Report in Design View. Change the required Margin Values in Memory. Copy the PrtMip Property Values of the Report into a 28 Bytes unbroken String Variable and action it into a redefined structured award arena during modification.
Update them controvert into the Report’s PrtMip Property. So subcontract into the open air us start. Save the Report with the changes and contribute it in Print Preview. Open a precise of your Databases with Reports in it. Insert (Insert – - > Module) a supplemental Standard Module (Global Module). Display the Visual Basic Editing Window (Alt+Fll).
Copy and paste the following Code into the supplemental Module and put away it.