Open drop down on focus

Q

quartz

I am using Office 2003 on Windows XP.

I would like to know how to have a combobox - the drop down portion - open
when the control receives focus.

Is this possible, if so can someone please post example VBA to do this?

Thanks much in advance.
 
M

Mikal via AccessMonster.com

quartz said:
I am using Office 2003 on Windows XP.

I would like to know how to have a combobox - the drop down portion - open
when the control receives focus.
Click to expand...

In the combo box's On Got Focus property put the following code:

Me!yourComboBoxName.dropdown

I think that will do the job.

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Link a text box based on drop down box with four options MS Word 365 0
Drop down list control value in vba 2
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Using Drop Down list to an If Statement to another Drop Down list 3
expand combo drop-down list at form open 1
Documents from shared model are created with design mode on 1
Data Validation and drop-down list using IF, AND and what else? 8

Top