How to collect user input in combo box ...

budgie · Joined: 04 Oct 2007 Posts: 40

Yep, me again with more problems Sad

but at least this should be easy for you
gurus.

I have a combo box with numbers (say) 1-99 available in a drop-down for the
users to choose from. However I am having a problem finding a means to
handle/collect user input when the user types a number into the box rather than
drop'n'scroll. This is a data entry aka selection that I want to support.

Short of watching every keypress event and waiting for a , how can I get the
user's (usually two-digit) entry?

Thanks for any constructive suggestions.

Archived from group: microsoft>public>vb>dos

Jonathan Rothwell · Joined: 04 Oct 2007 Posts: 7

Dear Budgie,

> I have a combo box with numbers (say) 1-99 available in a drop-down for
> the
> users to choose from. However I am having a problem finding a means to
> handle/collect user input when the user types a number into the box rather
> than
> drop'n'scroll. This is a data entry aka selection that I want to support.

Try using the event YourComboBoxName_CHANGE. This works in text boxes, but
I've not yet tried it with a combo box.
Hope this helps.

budgie · Joined: 04 Oct 2007 Posts: 40

On Sun, 02 Apr 2006 16:57:38 GMT, "Jonathan Rothwell"
wrote:

>Dear Budgie,
>
>> I have a combo box with numbers (say) 1-99 available in a drop-down for
>> the
>> users to choose from. However I am having a problem finding a means to
>> handle/collect user input when the user types a number into the box rather
>> than
>> drop'n'scroll. This is a data entry aka selection that I want to support.
>
>Try using the event YourComboBoxName_CHANGE. This works in text boxes, but
>I've not yet tried it with a combo box.
>Hope this helps.

That was one thing I tried, but it responds to *each* keystroke so I would have
to "build" the result. Also it doesn't avoid the generating a beep and
nothing else. I couldn't see a way to achieve an end-of-user-input when the
key is pressed.

I wound up (after much trial-and-error ) using _KeyUp event to SETFOCUS to the
next tabbed control when the character code was 13 (return). Not elegant, but
it worked.