Row Source Values

[jle0003]

What property do I set to limit a user's option in a combobox to only those in the Row Source Value? I do not want tohe users to be able to type in any values; only select from the dropdown.

Thanks!

[Robeen]

In the Property Sheet for the combo box -> Data Tab . . .
set 'Limit To List' = Yes.

[RuralGuy]

Set the LimitToList property True. You will then get a NotInList event where you can put up any message you want.

[jle0003]

I set 'Limit To List' = Yes on all of my comboboxes but I only get an error message on some when a value is entered that is not part of the dropdown list. It is inconsistent. Any ideas why?

[jle0003]

After looking at it more closely, I noticed that the fields where the Row Source Type is "Table/Query" it works fine. On fields where the Row Source Type is "Value List" it still allows user input. How can fix this?

Thanks!!

[RuralGuy]

Try setting the AutoExpand property True as well.