Drop Down Boxes in forms

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I have 4 drop down boxes with 7 choices in each box to choose from. I want
our users to just choose one of the choices from each box, and not be able
to add any information along with that choice. In other words just give them
the ability to choose a selection and that is it. Not being able to add any
text to that selection.

How can I lock each box out from adding any additional text?


Thank You so much for your help

Ken
 
Ken, Open the form in design view. double-click your combo box. This will
open the properties window. Click the Data tab and set the limit to list
property to Yes.
 
Reggie

Thanks for the fast response, but, I already did that. And I can still type
additional text in the box next to the selection. I just want the user to be
able to select a choice and not be able to type anything else in those
boxes.


Thanks
 
Ken said:
Reggie

Thanks for the fast response, but, I already did that. And I can still type
additional text in the box next to the selection. I just want the user to be
able to select a choice and not be able to type anything else in those
boxes.
Click to expand...

Yes, you can still type additional text, but it won't accept it when you tab out
of the control. LimitToList will not allow any entry that is not an exact match
for a row in the list.

There is no way to prohibit typing and still allow selecting.
 
Got It

Thank You for your help!!!!!

Rick Brandt said:
Yes, you can still type additional text, but it won't accept it when you tab out
of the control. LimitToList will not allow any entry that is not an exact match
for a row in the list.

There is no way to prohibit typing and still allow selecting.
Click to expand...
 
Back
Top