combo boxes, drop down boxes, multiple choices

[Jeanie]

I have a form that has some questions with a box beside each question. when you click on the box, it has a drop down list of choices to choose. I want to make a couple changes to this drop down list (sorry - not sure what it is actually called).

First, each choice in the list has both a text and numeric label. I want the list to show up in number order, it does not always do so.

Second, the box is currently set up so that if someone types in an answer it takes that typed in information. I want to force the user to choose one of the already available responses and not be able to type anything in the box.

And third (lastly), for some of the questions I want the user to be able to pick more than one of the choices.

Thanks for any help you can give!

Thx,

Jeanie

 

[TerpFan2001]

In a combo box, you can prevent users from entering there own data by setting the Limit To List Property (Under Data Tab) to Yes

To allow multiple selections in a list box change the MultiSelect Property (Under the Other Tab) from None to either Simple or Extended. Extended requires the user to hold down the shift key in order to make multiple selections.

As far as your first question is concerned, is the data for your combo box coming from a table/query or did you enter it manually?

 

[Jeanie]

The data is coming from a table.

Thanks a lot for all your help!

 

[Jeanie]

The box is a combo box. When I look for the MultiSelect Property (Under the Other Tab) it is not there. Does my box have to be a list box instead of a combo box? If so, is there anyway I can change all my boxes to list boxes or will I just have to create all new boxes?

 

[Jeanie]

The box is a combo box. When I look for the MultiSelect Property (Under the Other Tab) it is not there. Does my box have to be a list box instead of a combo box? If so, is there anyway I can change all my boxes to list boxes or will I just have to create all new boxes?

 

[TerpFan2001]

Jeanie:
I don't know of any way to have multiple selections in a combo box. To convert from one control to another (ie. combo to list) right click the control and select "change to..."