does access resets margins when distributing reports?

Hello all,

I have a few custom reports I've created for end-users, and it appears that, when I distribute the runtime .accde, access is resetting the margins. Does anyone know for sure if access 2007 does this?

I know you can set the paper size, and even margins with the report object, but I have found that using this code ONLY works if you first preview the report. For whatever reason, if you send the report straight to the printer with the acNormal command, it will ignore the margin and/or paper size commands.

Does anyone have ideas on a good solution, or should I just make them preview the report first, then print from the preview mode?

Many Thanks,

Andy

.

Relevant Pages

  • Re: basic invoiceing question
    ... To me a report is a report and an invoice is an invoice ... a 8 1/2 X 11 sheet. ... margins of the report, you're changing the size of the space that's ...
    (microsoft.public.access.reports)
  • Re: basic invoiceing question
    ... To me a report is a report and an invoice is an invoice ... report margins to 8.5x5.5 - that will give you *one* invoice per sheet. ...
    (microsoft.public.access.reports)
  • Re: printing double sided reports
    ... Try only running the code to "move margins" if the formatCount is 1 ... The problem report has multiple columns printed down and then across - the ... Dim MoveMargin As Integer ...
    (microsoft.public.access.reports)
  • Re: basic invoiceing question
    ... To me a report is a report and an invoice is an invoice ... report margins to 8.5x5.5 - that will give you *one* invoice per sheet. ...
    (microsoft.public.access.reports)
  • Re: Page Margin Surprises ... cant reset
    ... I'm having the same issue using Vista and Access 2007. ... to print won't change the margins to 0.25 each. ... I have one report which produces Avery Labels (for table name ...
    (microsoft.public.access.reports)