Solved

Disable zoom feature on an Access report

Posted on 2011-03-02
8
679 Views
Last Modified: 2016-01-26
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.  
0
Comment
Question by:dbfromnewjersey
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 50 total points
Comment Utility
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.

JeffCoachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
Why all the hatred towards the poor little Zoom magnifying glass...?

;-)

Jeff
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 200 total points
Comment Utility
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
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
MX

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


0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 200 total points
Comment Utility
Oh ... forgot about this - actually what I was looking for ...

Custom Zoom in Reports
http://www.mvps.org/access/reports/rpt0020.htm

mx

jeff ... yes ODD.  Miriam say Hi !
0
 

Author Comment

by:dbfromnewjersey
Comment Utility
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)
0
 

Author Comment

by:dbfromnewjersey
Comment Utility
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.
0
 
LVL 8

Expert Comment

by:Abhigyan Srivastava
Comment Utility
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.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now