combo box selection overwrite issue

  • Thread starter Thread starter Pamela
  • Start date Start date
P

Pamela

We have a combo box on a form. When you start typing i auto populates with
the closest record and keeps it highlighted so if you keep typing it keeps
pulling the next closest. It works fine with all records except one. if you
type in Ho it comes up with the closeest records to that but instead of
keeping it highlighted so you can type over it changes to insert typing and
anything you type just goes after the Ho but all the other text it auto
populated is still there. So if you want to select any other record that
start with Ho you have to scroll through the list. I haev looked at I cannot
see anything different with that recrod than all the others.
Please help.

Thanks,
 
Pamela said:
We have a combo box on a form. When you start typing i auto populates with
the closest record and keeps it highlighted so if you keep typing it keeps
pulling the next closest. It works fine with all records except one. if
you
type in Ho it comes up with the closeest records to that but instead of
keeping it highlighted so you can type over it changes to insert typing
and
anything you type just goes after the Ho but all the other text it auto
populated is still there. So if you want to select any other record that
start with Ho you have to scroll through the list. I haev looked at I
cannot
see anything different with that recrod than all the others.
Please help.

Thanks,
Click to expand...
 
We have a combo box on a form. When you start typing i auto populates with
the closest record and keeps it highlighted so if you keep typing it keeps
pulling the next closest. It works fine with all records except one. if you
type in Ho it comes up with the closeest records to that but instead of
keeping it highlighted so you can type over it changes to insert typing and
anything you type just goes after the Ho but all the other text it auto
populated is still there. So if you want to select any other record that
start with Ho you have to scroll through the list. I haev looked at I cannot
see anything different with that recrod than all the others.
Please help.

Thanks,
Click to expand...

There's something corrupted somewhere! Try Tools... Database Utilities...
Compact and Repair (or in 2007, click the Office button, Manage, and compact).
If that doesn't help, try deleting the combo box, compacting, and recreating
the combo.
 
Back
Top