Restrict input in combo box

A

Anna

I want to restrict user to type in combo box but must select from the list. Appreciate if anyone can help me. Thanks.
 
N

Nikos Yannacopoulos

Anna,

Open your form in design view, right click on the combo box and select
properties. On the Data tab of the Properties window, locate property Limit
to List, and change its value to Yes.

HTH,
Nikos

Anna said:
I want to restrict user to type in combo box but must select from the
list. Appreciate if anyone can help me. Thanks.
 
R

Rick Brandt

Anna said:
Thanks for the suggestion. I tried but still it allows me to type. Is
it possible to restrict from typing but just choose from the list?

No.
 
R

Rick Brandt

Rick Brandt said:
it possible to restrict from typing but just choose from the list?

No.

I take that back. You can put the following in the KeyPress event of the
ComboBox.

KeyAscii = 0

All keystrokes will then be ignored. They could still paste into the
control, but I don't know if that would be an issue.
 
Top