Enforce combo box

[Guest]

Hi,
For my Access 2000 application, on my input form, I have a combo box. How
can I force the user, input the data only by select from the list available
not by typing. Thanks for your kindly advise.

 

[Guest]

If you wnat them not to be able to type anything new into the box, you can
set the limit to list property to yes, and then deal with it by way of
message with the on not in list event,
or,
if you want them to click it rather than type, if you set tabstop to 'no'
they will have to use the mouse to open it, if you then want to prevent
typing completely you will have to do some coding in the on_change event,
possibly just a message.

TonyT

 

[B F Cole]

Set the "Limit to List" property to Yes. The user can still type in the box
and will "auto match" entries in the box, but can not add new entries to the
box.

Bill