Editable DropDown Listbox

[Tim Philomeno]

I have a need to allow the user to type into a dropdown listbox without the
dropdown activating...they know the EmpID for example, so they just want to
to type it in....is this something I have to build using stacked
controls/visible properties/and buttons? or is this functionality available
somehow?

Thanks
Tim Philomeno

 

[maor110]

If you find a way for stacking controls please post it here.

But I think this functionality isn't available somehow. If you have very
much time, write a activeX control, otherwise find another way.

Regards
Paul Degenkolbe

 

[Scott L. Heim [MSFT]]

Hi Tim,

This functionality is not available but what you may be able to do is
implement the "stacked" controls as you suggest in the following manner:

- Add a text box control
- Add a drop down control immediately next to the text box
- In the OnAfterChange event of the text box, execute your query to look up
the entry. If found, the data will get populated - if not, display a
message indicating it was not found and to make a selection from the list.
At that point, display the drop-down and hide the text box.

Just a thought...

Best regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.