Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    A quick tip - implementing ZOOM on a form (Access 2K, Win2KPro)

    This isn't a question, just a little tip that I thought people might find handy.

    Problem: you have a form with textboxes and the source information may have very long text to display in the box. You don't want to set the boxes to Grow as this will make the form unweildy for really long text.

    Solution: invoke Access's native Zoom command on the textbox via, say, a button:

    Private Sub ZoomButton_Click()
    Me.[Form Field Text Box to Zoom on].SetFocus
    SendKeys "+{F2}"
    End Sub

    This will make access bring up the Zoom window (which is already set as a pop-up). This will give you a consistent interface with very little work.

    I know some people tend to run screaming when SendKeys is used but in this case you shouldn't have any problems.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: A quick tip - implementing ZOOM on a form (Access 2K, Win2KPro)

    And for those who tend to run screaming when SendKeys is used: RunCommand acCmdZoomBox is the equivalent of SendKeys "+{F2}".

    Nice tip, though.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A quick tip - implementing ZOOM on a form (Access 2K, Win2KPro)

    thanks for reducing the potential amount of running and screaming. now, if you could keep people from running with scissors... <img src=/S/flee.gif border=0 alt=flee width=25 height=25>

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A quick tip - implementing ZOOM on a form (Access 2K, Win2KPro)

    Hi Steve

    Thanks for the tip, you want to look at the following (Zoom) for another approach to zoom on text box.

    I use Double Click, F4 or Ctrl +Down Arrow to open these forms.

    HTH

    John

    Popups Database. (29KB ZIP File)

    http://easyweb.easynet.co.uk/~trevor/AccFA...oads.htm#popups

    A small mdb containing a few popup forms that you can call up from your forms to add functionality and ease of use to your applications.

    For text boxes you can use the Zoom box, like [Shift]+F2 but bigger and with customisable font & font size / style selection.

    For numeric fields, there's a calculator that will return the result straight to your field.

    And lastly, for dates there's the calendar, just like the OCX one that ships with the ADT but uses no OCX.
    This is my favorite Popup.mdb, works similar to calendar in Quicken.

    It also includes a calculator and text/memo zoom box

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •