Restrict input in combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to restrict user to type in combo box but must select from the list. Appreciate if anyone can help me. Thanks.
 
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
Click to expand...
list. Appreciate if anyone can help me. Thanks.
 
Anna said:
Thanks for the suggestion. I tried but still it allows me to type. Is
Click to expand...
it possible to restrict from typing but just choose from the list?

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

No.
Click to expand...

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.
 
You must log in or register to reply here.

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

Restricting one Combo box based on the selection in another field 2
Microsoft Access 2003 - Form / Combo Box 3
Cascading Combo Box Questions 7
Simple problem of combo box 1
User restrictions? 4
combo box data type 1
Filter subform somehow! 6
Overwhelmed, Just Started, Quick Question 3

Back
Top