Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Jan 2004
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Call the Zoom box

    I want to enable the zoom box view from a field in an Access97 form by clicking on a button. The Sendkeys in a macro does not work, or I am doing something wrong.

    Any help is appreaciated.

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Call the Zoom box

    Check the syntax of the macro. It should look exactly like:<pre>+{F2}</pre>

    That should work for you... <img src=/S/trophy.gif border=0 alt=trophy width=15 height=15>

  3. #3
    New Lounger
    Join Date
    Jan 2004
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Call the Zoom box

    Yes that should work, but it doesn't. I have tried moving the focus to the field first, but that doesn't work either.

    I basically need a larger edit box for users for a memo field.

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Call the Zoom box

    Hmmm.....I got it to work with no problem (both Access 97 and 2000). Try this code:<pre>Private Sub cmdZoomBox_Click()
    YourFieldName.SetFocus
    SendKeys "+{F2}"
    End Sub</pre>

    Just keep in mind that you'll have to have a separate button for each field that you want this to work for.

    Post again if you still can't get it and we'll keep looking for a solution. <img src=/S/salute.gif border=0 alt=salute width=15 height=20>

  5. #5
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Call the Zoom box

    How about:

    me!yourtextbox.setfocus
    Application.RunCommand acCmdZoomBox

  6. #6
    New Lounger
    Join Date
    Jan 2004
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Call the Zoom box

    Thanks MarkJ and Cpod. I tried Mark's solution and it worked.

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Call the Zoom box

    You can also check out the attached zoombox I found on this forum a while ago:
    Attached Files Attached Files

Posting Permissions

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