Results 1 to 3 of 3
  1. #1
    ashu.doc is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2012
    Posts
    124

    Combobox drop down on click

    Hi
    How can I change the way combobox shows the row source values, I want to just click ON the combobox not the down arrow, to show the list?
    Thanks

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    Try

    Me.ComboName.Dropdown

    In its got focus event.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Paul's suggested method for doing this is pretty much the standard way. The OnClick event of a Combobox doesn't fire until you click on a selection from the dropdown list! You could use the code he gave you in the DoublelClick event, which will fire when you double click on the Combobox itself, OnFocus is really the way to go for this.

    Linq ;0)>

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Easy Solution to Prevent Combobox Drop-down
    By benthamq in forum Forms
    Replies: 1
    Last Post: 01-20-2013, 01:13 PM
  2. Change fields based on a combobox click
    By Richie27 in forum Programming
    Replies: 5
    Last Post: 05-31-2012, 08:01 AM
  3. Replies: 3
    Last Post: 11-29-2011, 07:01 AM
  4. On click textbox inserts value back on combobox
    By whitelockben in forum Forms
    Replies: 2
    Last Post: 10-09-2011, 05:23 AM
  5. Replies: 9
    Last Post: 12-18-2010, 12:51 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums