Re:Making a combox or listbox show list on_focus 1

[KirkJewell]

I want to make a combobox auto show the list when the user moves the cursor in to it. I managed to do this a couple of years ago (and was told by my client that they didnt like it) and have since forgotten how. [sig][/sig]

 

[THoey]

Add the following to your combo box's GotFocus event:

Sub cboMyBox_GotFocus()
Me!cboMyBox.DropDown
End Sub

Hope that helps... [sig]<p>Terry M. Hoey<br><a href=mailto:th3856@txmail.sbc.com>th3856@txmail.sbc.com</a><br><a href= > </a><br>Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?[/sig]

 

[KirkJewell]

Thanks for that! I manage to get it to work by using :-

SendKeys &quot;%{Down}&quot;

I will use your suggestion because it is more elegent and far less likely to cause errors. (I had actually tried the dropdown method, but as a property ( e.g. = True) DOH!)

Regards
Kirk
[sig][/sig]