Input value by Combox only

[accessman2]

Hi,

In MS Access, the form,

I make one combox, I want anybody input the value by dropdown list, they cannot input the value by typing in keyboard.

How can I lock to enter the value by typing, but they can input it by dropdown list.

Because, if I lock the field, then we never enter the value, if no lock, then we can enter it either dropdown list option or type in keyboard.

I just want to make dropdown list option to enter the value.

Please let me know, thanks.

 

[RV]

Use a list box, not a combo box.

RV

 

[sierra467]

On the combobox, change the Limit to List Property on the Data tab to "yes" and that will prohibit users from typing something in on the keyboard.

 

[ScottGem]

There is no way to block them from using the keyboard. They can still type in a value instead of picking one. However, if you set the LimitToList property of the combo to Yes, they will get message that the value isn't in the list and it won't be accepted.