Combo box and typing

[AmandaH]

I have a combo box with is linked to a column in a table. This column
can only have the values that are already listed in the combo box. How
do I prevent the user from entered any other values then what is
listing in the combo box?

~Amanda~

 

[Guest]

Amanda,

Set the combo box' LimitToList property to Yes.

Sprinks

 

[Jeff Boyce]

Amanda

Are you saying that you have a field in a table that is set up as a "Lookup"
data type? Or are you saying you have a combo box control on a form?

If the former, stop now! Scan the tablesdbdesign newsgroup for reasons why
using "lookup" data type fields in tables is a bad idea.

If you are using a combo box in a form, you can open the form in design
mode, select the combo box and modify its "LimitToList" property. Note that
you can't do this if you are working in the table directly.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Pieter Wijnen]

Set the limit to list property to yes

Pieter

I have a combo box with is linked to a column in a table. This column
can only have the values that are already listed in the combo box. How
do I prevent the user from entered any other values then what is
listing in the combo box?

~Amanda~