Can I prevent free text entry in combo boxes (in forms)

  • Thread starter Thread starter Mes
  • Start date Start date
M

Mes

Hello all

Is there a way I can prevent free text entry in a combo box without
having to change it to a list box? I don't know VB and have searched
the help files and the Access Bible with no luck, so I'm thinking this
is not possible.

I have a form with a combo box for selecting a location, run off a
simple query. I don't want anyone being able to type in anything other
than what's in the list. I want to avoid using a list box partly
because of the lack of space.

Thanks in advance for any help...

Mes
 
Mes said:
Hello all

Is there a way I can prevent free text entry in a combo box without
having to change it to a list box?
Click to expand...

Simple. Set the LimitToList property of the combobox to True.
 
Back
Top