Report preview

R

Ray

Whenever I preview reports they always come up as too big
to fit in the screen. Ideally I would like all reports to
preview at about 75% of normal size. Is there a parameter
that I can set to make this happen, either golobally or
for individual reports?
 
W

Wayne Morgan

You can set AutoResize to Yes in the report's Properties sheet, Format tab. This will
cause it to open to Fit. You can also zoom the report using RunCommand acCmdZoom75, but
try to do this from within the report seems to be almost impossible. The only place I've
found it to work is in the Retreat event of one of the report's sections and, of course,
it will only work there if the Retreat event is run. Once the report is open, you can run
this command from some other object, but of course at that point you could also just use
the zoom selection on the toolbar, so this doesn't help much.
 
M

Marshall Barton

Ray said:
Whenever I preview reports they always come up as too big
to fit in the screen. Ideally I would like all reports to
preview at about 75% of normal size. Is there a parameter
that I can set to make this happen, either golobally or
for individual reports?

No global setting for this. You can do it individually when
you open the report via the click event of a command button
on a form:

Docmd.OpenReport . . .
DoCmd.RunCommand acCmdZoom75
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top