Hi, Jennifer.
Is there a way to change this default to "100%" instead of "Fit" so
that we don't have to change the settings each time?
Open the report in Design View and open the Properties dialog window.
Select the "Format" tab and select the "Auto Resize" Property. Change it to
"No." (You may also want to stretch the window so that it is wider and
taller or in a different place on the screen, or even change the Zoom toolbar
combo box to 100% or another value.) Save the report, then open it by
double-clicking the name of the report in the Database Window. Experiment
with the size, placement and zoom % of the report's window until you are
satisfied.
If the report is opened from code, the "Auto Resize" Property still needs to
be set to "No," but the following line of code could also be added to the
procedure:
DoCmd.OpenReport sRptName, acViewPreview
RunCommand acCmdZoom100
.... where sRptName is the name of the report that is to be opened in preview
mode.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
