Can't scale reports with Access 2003 runtime

[Alvin]

I know there are numerous posts on manipulating the DevMode property on the
report to support scaling, page orientation and so forth. However, the
procedure seems to work only when the code temporarily flips a report into
design mode which is not possible in the Access runtime version. Any other
report that is not letter sized (legal, A3, etc) are chopped off and spooled
onto the next page. Is there an alternative way to programmatically scale
reports?

Oh and by the way, it's not feasible to replace all printers to support all
page types.

 

[Larry Linson]

I know there are numerous posts on manipulating the
DevMode property on the report to support scaling,
page orientation and so forth. However, the procedure
seems to work only when the code temporarily flips a
report into design mode which is not possible in the
Access runtime version.

Unless my memory is failing me, the runtime disables _display_ of design
view, but does not prevent you from working in design view in code. Perhaps
you were not making all the design changes from VBA code, or perhaps
something else gave you the impression that you could not do this.

Any other report that is not letter sized (legal, A3, etc) are
chopped off and spooled onto the next page. Is there an
alternative way to programmatically scale reports?

No... what, exactly, did you have in mind by "scaling reports"? Unlike some
other Office software, Access doesn't have a "fit to page" or similar
option.

Oh and by the way, it's not feasible to replace all printers
to support all page types.

I find it difficult to imagine that someone with any knowledge of business
environments would make such a suggestion, unless this were a truly
make-or-break business-critical application.

Larry Linson
Microsoft Access MVP

 

[Alvin]

Hi Larry,

Here is a link of similar code that I'm using to scale reports:
http://msdn.microsoft.com/archive/d...umControllingYourPrinterinMicrosoftAccess.asp

Essentially, we have different reports that use different sized paper (A3,
letter, legal and etc) but all ours printers support letter-sized paper we'd
like to resize all reports to print on letter-sized paper. We have a table
that lists all the reports to print out plus print properties (orientation,
scale, paper size). We currently have a generic function that resizes the
report for letter-sized paper by overriding the scale and papersize
attributes in the prtDevMode property while the report in code is flipped
into design mode. The code works for Access 2003 Professional on an HP
printer which resizes a legal-sized report to fit on a letter-sized page.
But in the Access 2003 runtime, the report remains legal size and the excess
cut off by the page margins which is printed to every 2nd page.

Alvin

 

[Alvin]

Hi Larry,

Sorry I got confused especially when reading posts like
"http://msdn2.microsoft.com/en-us/library/aa139946(office.10).aspx" when it
states "Additionally, because the PrtDevMode, PrtDevNames, and PrtMip
properties are available only when a form or report is open in Design View,
it is not possible to use them from Access applications saved as .mde or .ade
files or from Access runtime applications because those file types don't
support opening forms and reports in Design View." But apparently, scaling
in Access runtime does work when I choose a printer that supports scaling. I
should've tested it against the same printer for both professional and
runtime versions.

Alvin

 

[Larry Linson]

Sad to say, although this is an interesting subject, I am not an appropriate
authority on doing what you want, even in the retail version. To expedite
implementation, my clients have always preferred to have reports "to the
lowest common denominator" -- in their case, Letter size. They wanted to
invest in new features and function of their applications, not nitty-gritty
detail things that required "going out of our way" to circumvent what the
software did as a "norm."

Perhaps someone else can, and will, step in, with words of wisdom.

Larry Linson
Microsoft Access MVP

 

[Larry Linson]

I know there are numerous posts on manipulating the DevMode property on the
report to support scaling, page orientation and so forth. However, the
procedure seems to work only when the code temporarily flips a report into
design mode which is not possible in the Access runtime version. Any other
report that is not letter sized (legal, A3, etc) are chopped off and
spooled
onto the next page. Is there an alternative way to programmatically scale
reports?

Oh and by the way, it's not feasible to replace all printers to support
all
page types.

 

[Stephen Lebans]

Hi Alvin,
what exactly are you trying to accomplish here?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.