Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Expand contents of combo box on enter (Access 97)

    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?

  2. #2
    Star Lounger
    Join Date
    Dec 2001
    Location
    Birmingham, Alabama USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Expand contents of combo box on enter (Access 97)

    Use the On Got Focus event:

    Me.YourComboName.Dropdown

    Or you could simply use:

    Me.ActiveControl.Dropdown

    HTH
    RDH
    Ricky Hicks
    Microsoft MVP
    Birmingham, Alabama USA

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Expand contents of combo box on enter (Access 97)

    That was simple ....many thanks!

  4. #4
    Star Lounger
    Join Date
    May 2001
    Location
    Ventura, California, USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Expand contents of combo box on enter (Access 97)

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

  5. #5
    Star Lounger
    Join Date
    Dec 2001
    Location
    Birmingham, Alabama USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Expand contents of combo box on enter (Access 97)

    You are welcome .... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    I was just slightly faster responding than rpwoods.

    RDH
    Ricky Hicks
    Microsoft MVP
    Birmingham, Alabama USA

Posting Permissions

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