• Expand contents of combo box on enter (Access 97)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Expand contents of combo box on enter (Access 97)

    Author
    Topic
    WSramonas
    AskWoody Lounger
    December 18, 2001 at 7:29 pm #364322

    I know it’s possible to expand/open the contents of a combo box when the combo box has the focus or “on enter”, however, I don’t remember how I did it before. Anyone have any suggestions?

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WSR. Hicks
      AskWoody Lounger
      December 18, 2001 at 7:38 pm #558896

      Use the On Got Focus event:

      Me.YourComboName.Dropdown

      Or you could simply use:

      Me.ActiveControl.Dropdown

      HTH
      RDH

      Reply | Quote
      • WSramonas
        AskWoody Lounger
        December 18, 2001 at 7:39 pm #558898

        That was simple ….many thanks!

        Reply | Quote
        • WSR. Hicks
          AskWoody Lounger
          December 18, 2001 at 7:54 pm #558901

          You are welcome …. smile

          I was just slightly faster responding than rpwoods.

          RDH

          Reply | Quote
    • WSrpwoods
      AskWoody Lounger
      December 18, 2001 at 7:45 pm #558899

      Use the dropdown method, as in
      Private Sub SupplierID_GotFocus()
      Me!SupplierID.Dropdown
      End Sub

      Reply | Quote
    Viewing 1 reply thread
    Reply To: Expand contents of combo box on enter (Access 97)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.