MS Access: is it possible to manipulate the zoom box?

Posted on 2007-10-01
Medium Priority
Last Modified: 2012-03-06
I'm using
DoCmd.RunCommand acCmdZoomBox
to open the zoom box with a textbox's double-click event. The problem is the size of the zoom box isn't a whole lot bigger than the textbox so I'm not gaining a whole lot using it.

Is there anyway to increase the size of the zoom box? Also would like to know if it's possible to set the default font and NOT have the zoom box contents selected (highlighted) by default when it opens.
Question by:michaelcpaul
LVL 66

Expert Comment

by:Jim Horn
ID: 19992092
Hmm.. let's see, how do I put this..  which way to go...  

(1)  Click once inside the contents of the zoombox, {ctrl}-A to select all, {ctrl}-C to copy, close, go to a query, go into SQL View, {ctrl}-V to paste contents of zoom box into new query, and work from there.

(2)  If you have that much logic in a zoom box, then perhaps this should all be done in a query, and not a form.control property.

LVL 77

Expert Comment

ID: 19992217
Hi Jim - are you looking at your own personal version of this question?
Or am I?


Author Comment

ID: 19992220
jimhorn, looks like I need to clarify:

I don't want to do anything with the zoom box other that be able to see all of the contents of the textbox on which I'm zooming. The textbox is too small to show all of the contents in some cases; thus calling the zoom box. When the zoom box opens, it is larger than the textbox so it helps some, but I would like the zoom box to be larger. Also, when the zoom box opens, the text is highlighted as though it has been selected. I can unselect it by clicking in the zoom box, but this is an extra step I'd like to avoid, if possible.
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

LVL 75
ID: 19992254
"open the zoom box with a textbox's double-click event"

I would suggest and HIGHLY recommend - from a usability standpoint - that do not use Double Click to do this.  In *most* places in Windows apps where there is a text box ... double clicking hi-lights (ie, selects) the text or part of the text ... just like in this window I am typing in now ... if I double click the word 'text' ... it is selected. So, by doing what you propose, you override a standard Windows mechanism.

I use Shift + Double Click to perform that function, so ... all you have to do is determine if the Shift key is depressed when the Double Click (event) occurs ... then you open the Zoom box.

Note that Shift + F2 also opens the Zoom box.

LVL 66

Accepted Solution

Jim Horn earned 750 total points
ID: 19992275
>Is there anyway to increase the size of the zoom box?
afaik no, the zoom box is not expose its height and width properties such that a user can change them.

>Also, when the zoom box opens, the text is highlighted as though it has been selected.
Not sure on this one.

>Hi Jim - are you looking at your own personal version of this question?
Not sure what you mean here.

Author Comment

ID: 20040294
DatabaseMX - appreciate the recommendation. However, in this case double-clicking in the window selects a word, and the simplicity of a single click far outweighs the loss of this functionality (again for my particular application).

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

840 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