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

Posted on 2007-10-01
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 65

    Expert Comment

    by:Jim Horn
    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

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


    Author Comment

    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.
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    "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 65

    Accepted Solution

    >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

    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

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    734 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

    23 Experts available now in Live!

    Get 1:1 Help Now