By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,991 Members | 1,917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,991 IT Pros & Developers. It's quick & easy.

Combo list expand on enter.

P: 72
Hello again,

In Access 2k3, I need for the combo list to auto expand when the user tabs into the field, or click on the field. I saw that there is a DropDown command, is that correct? Just typed that in the field properties event onenter or onclick?

Thanks you.
Mar 20 '07 #1
Share this Question
Share on Google+
6 Replies


P: 72
Welp, that did not work. Still looking.
Mar 20 '07 #2

P: 72
Welp, so far I havent found anything, or maybe I am searching for the wrong thing.
Mar 20 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Welp, so far I havent found anything, or maybe I am searching for the wrong thing.
You need an event procedure on the On Enter event as follows:
Expand|Select|Wrap|Line Numbers
  1. Private Sub ComboName_Enter()
  2.     Me!ComboName.Dropdown
  3. End Sub
  4.  
Mary
Mar 22 '07 #4

ADezii
Expert 5K+
P: 8,619
Hello again,

In Access 2k3, I need for the combo list to auto expand when the user tabs into the field, or click on the field. I saw that there is a DropDown command, is that correct? Just typed that in the field properties event onenter or onclick?

Thanks you.
You can also place this code in the GotFocus() Event of the Combo Box:
Expand|Select|Wrap|Line Numbers
  1. SendKeys "{F4}"
Mar 22 '07 #5

P: 72
You need an event procedure on the On Enter event as follows:
Expand|Select|Wrap|Line Numbers
  1. Private Sub ComboName_Enter()
  2.     Me!ComboName.Dropdown
  3. End Sub
  4.  
Mary

Thank you Mary and Dezii

Quick questions, these event codes they cannot be done thru the UI, but have to done in the VBA editor, right? I tried the dropdown event, but I may have tried it in the wrong field. Will ck.
Mar 27 '07 #6

MMcCarthy
Expert Mod 10K+
P: 14,534
Thank you Mary and Dezii

Quick questions, these event codes they cannot be done thru the UI, but have to done in the VBA editor, right? I tried the dropdown event, but I may have tried it in the wrong field. Will ck.
Yes these are both event driven codes.
Mar 27 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.