List Box

[Pass-the-reality]

I have a list box that is tied to a query. I want to use the list box (not a
combo drop down box) but be able to also type free text in the field if
needed. Do I need to change a property setting? When I try to type in the
list box it only allows me to select from the options, not type.

 

[John Spencer]

That is not the way a listbox works. I only displays existing data and
lets you select from the existing data.

You could develop a subform to do what you are asking and display the
subform on your main form (single form view only).

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Ken Sheridan]

You can't do that with a list box, only a combo box whose LimitToList
property is False. Even then, if the column to which the combo box is bound
is a foreign key referencing the key of another table, as is commonly the
case, you will be unable to enforce referential integrity in the relationship
between the referenced and referencing tables.

You can, if using a combo box, whose LimitToList property is True, insert a
row into the referenced table via the control's NotInList event procedure if
the value is not represented in the combo box's list, thus allowing
referential integrity to be enforced. You cannot do this with a list box,
however. A list box is more intended for use as an unbound control for
record navigation, filtering of output etc, rather than as a bound control.

Ken Sheridan
Stafford, England