Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 393
  • Last Modified:

how to set LeftMargin in Page Setup dialog

I am using Access 2002 VBA.

How can I set the LeftMargin property in VBA so that the change shows in the Page Setup dialog?

When I use the Printer object (ex. Printer.LeftMargin = 1) the change does not show up in the dialog, even if I first open the dialog before setting the property.
0
RicB
Asked:
RicB
  • 3
  • 2
1 Solution
 
nexusnationCommented:
i would set the report's margin to the proper result using code, not using the printer object.


getting the idea?

Andrew
0
 
RicBAuthor Commented:
Thanks, nexusnation

Actually, I just figured out how to do it by using Me.Printer.LeftMargin within the report code.

But I would still like to know how to set the left margin of a report using code - there is no LeftMargin report property and the Left property is read only.

Any ideas?
0
 
nexusnationCommented:
i will look now...
0
 
nexusnationCommented:
Ah, i found it. it is called the PrtMip Property. open up Visual Basic and search for the "PrtMip property" in help to find all of the information on it (too much to paste here). you can change all of the print settings with this property...

Andrew
0
 
RicBAuthor Commented:
This is exactly what I was looking for!

Thanks for the help, nexusnation.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now