Disable zoom feature on an Access report

Is there a way to disable or remove the zoom in / zoom out feature when viewing an Access report on the screen?  It's extremely annoying. When I run an Access query whose results are displayed on screen in an Access Report, I don't want the magnifying glass that allows the user to zoom in or zoom out. I hate that feature.  
Who is Participating?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Oh ... forgot about this - actually what I was looking for ...

Custom Zoom in Reports


jeff ... yes ODD.  Miriam say Hi !
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
The easiest way?

What version of Access please?

In Access 2007 and newer you can open the report explicitly in "Report View"

    DoCmd.OpenReport "YourReport", acViewReport

But bear in mind that most code on the Reports Format events will not fire in Report View.

Jeffrey CoachmanMIS LiasonCommented:
Why all the hatred towards the poor little Zoom magnifying glass...?


Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
I dont think so, but ... you can control the Zoom amount when it opens ... at this line it the Report Open event.  There are  several values you can pick from (25, 50, etc)

Docmd.RunCommand acCmdZoom75
Jeffrey CoachmanMIS LiasonCommented:

Odd that you can Right click the Status bar and customize it, but there is no option to turn off the Magnifying glass...

dbfromnewjerseyAuthor Commented:
Hi.  I wasn't able to look at any responses last night but to answer the questions above, I'm using Access 2003.   As far as my hatred of the zoom feature:  when output is sent to the screen for the user to review, I like it to be "static" for lack of a better term.  I don't like things sizable, moveable, minimizable, etc. I like the user to be presented with the data on a stationary screen with no options other than closing the screen or printing. I can't stand when there are various options available to the user. That's why whenever I create output screeens, I try to get rid of all toolbars, scroll bars, etc unless absolutely necessary for use with the output. I like bare bones output with minimal features (closing the the window to exit or return to the previous screen or to print. That's it. Nothing else)
dbfromnewjerseyAuthor Commented:
OK thanks.  guess i'll try to output the data to a form instead for on-screen viewing. I hate that the data is sizable on screen on a report. Absolutely hate it.  That's one of the reasons in a prior question I was outputting the data to a form for on-screen viewing but using a report when I needed to print the data.
Abhigyan SrivastavaCommented:
No. Unfortunately you can't.

There is however a command

DoCmd.RunCommand acCmdZoom100 where acCmdZoom100 refers to 100% zoom but it usually works with reports only and not with forms.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.