cbo help

[Guest]

i have a combo box showing hospitals names.Like "the harley street hospital"

and i use my form enter patients data. when i reached the field , i want
just to type "harley" to select the hospital.do i need to have a new field
with short form in the table"hospitals" i.e.for the above hospitals the short
form to be entered as Harley" or what should i do.
the cbo list i whant it to show the full hospital names.

 

[Rick Brandt]

i have a combo box showing hospitals names.Like "the harley street
hospital"

and i use my form enter patients data. when i reached the field , i
want just to type "harley" to select the hospital.do i need to have a
new field with short form in the table"hospitals" i.e.for the above
hospitals the short form to be entered as Harley" or what should i do.
the cbo list i whant it to show the full hospital names.

The AutoExpand behavior would let you do this as long as you enter the
characters at the beginning of the name. To enter "harley" when you really want
"the harley street hospital" could be difficult.

When you say..."the cbo list I want it to show the full hospital names"...do you
mean in the drop down list, what you see after making a selection (list not
dropped), or both?

You can add a field to the table used for the RowSource of the ComboBox and
enter one value while another value is stored, but whatever you see when the
list is dropped is what you have to type and that also has to be what you see
when the list is not dropped.

You could have another shorter field that you type and see in the ComboBox,
while displaying in a nearby TextBox the longer value. Would that suffice?