[AccessD] Simple Print Preview Question

This may be gilding the lily a bit, but in a commercial product I developed
and sell I have a preferences form for several parameters - one of which is
the zoom percent - it's a front end preference - so that the user can set
the magnification of the reports to suit their display and eyesight.  I
carry the zoom percent in a global variable and set it like this:

    DoCmd.OpenReport stDocName, acPreview
    DoCmd.SelectObject acReport, stDocName
    Reports(stDocName).ZoomControl = gintPreviewZoomPerCent

Those three statements could be put into a function and you can then just
pass the report name to it.

HTH somebody

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal
Sent: Tuesday, August 31, 2010 5:43 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Simple Print Preview Question

Forcing a report to open at 100% zoom level ===============================

Bud,

    In Access 2003 onwards, two new properties have become available on
format tab of report's property sheet as follows:
    (a) Auto Resize (default value: Yes)
    (b) Auto Center (default value: No)

    If you open the report in design view, set its Auto Resize property to
No and save, it will thereafter always open at 100% zoom level. While at it,
you might also like to set the Auto Center property to Yes.

    In Access 2000, although above properties are not exposed, its default
style is to open at 100% zoom level.

    Note:
    Placement of code in report's open event for maximization of window and
attaining the desired zoom level has the drawback that in such a case, the
report does not get depicted on the task bar. Thus any such code, if used,
should preferably be placed in the calling form's module. A generic
subroutine like OpenReport() as suggested in David's post, could be used.

Best wishes,
A.D. Tejpal
------------

  ----- Original Message -----
  From: Jim Dettman
  To: 'Access Developers discussion and problem solving' 
  Sent: Tuesday, August 31, 2010 03:50
  Subject: Re: [AccessD] Simple Print Preview Question

    I've never seen that exposed anywhere either...

  JimD. 

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
  Sent: Monday, August 30, 2010 5:54 PM
  To: 'Access Developers discussion and problem solving'
  Subject: Re: [AccessD] Simple Print Preview Question

  Hi Bud:

  There might be a way but I have never found one... If the report is saved
at
  a maximum size it will most likely expand to the full screen next time it
is
  called in an application but not always.

  You can put the two second commands in the report onopen event but then
you
  will get a flash and you may not want that. I would stick code to display
a
  full screen background, turn off the repaint, use your method to expand
the
  report, and then repaint.

  HTH
  Jim
    

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bud Goss
  Sent: Monday, August 30, 2010 2:07 PM
  To: Accessd
  Subject: [AccessD] Simple Print Preview Question

  When I do a print preview my report is displayed at 50% magnification. If
I
  left click on the report it changes to 100 %. If I left click on the
report
  again, it goes back to 50 %. 

  I can change this behavior by using the following code

  DoCmd.OpenReport stDocName, acPreview
  DoCmd.Maximize
  DoCmd.RunCommand acCmdZoom100

  With this code, the report is initially displayed with 100 %
magnification.

  Is there a way to set a database property to get 100% magnification
  initially without using the:
  DoCmd.Maximize
  DoCmd.RunCommand acCmdZoom100

  statements every time I request a print preview?
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com