One of the many combo boxes will not autoexpand

[Ben Pelech]

Hello,

I have been trying to figure out a problem with one combobox on my form that
is not acting properly. When I start typing in the combobox nothing happens,
as in it doesnt start filling in my selection/autoexpand and will not even go
to the letters that I typed in. All the other comboboxes are working fine.
They all start filling in the box as I type in and will go to the appropriate
name. This box has 191 possible choices.

Am I missing something obvious? I have tried deleting the combobox and the
associated table, and then re-adding them both back, but it still isnt
working. I have disabled the autoname function cause I heard that may cause
problems. I have tried using the Select Distinct function and that isnt
working either.

Any help would be greatly appreciated.

Thanks

Ben

 

[Allen Browne]

Tell us more about the problem combo Ben:
- ControlSource: what kind of field is this in its table? (Text? Number?)
- RowSource: post the sql statement
- Bound Column
- Column Count
- Column Widths
- Format

Are you able to edit other controls on this form okay?

 

[Peter Hibbs]

Ben,

Coincidentally I had exactly the same problem on one of my client's
databases recently. Everything worked except for one combo box which
was showing nothing (instead of a list of customer names from a
table). It turned out that there was a corrupted record in the table
which, for some reason, prevented ANY records being shown. It may not
be your problem but I suggest you check all 191 records in the table
for invalid data.

HTH

Peter Hibbs.

 

[Ben Pelech]

It works. Thank you so much. Apparently it was because I copied these names
from excel and the formatting was messed up.

Thanks again!!!

 

[Peter Hibbs]

Ben,

Excellent, glad you fixed it OK.

Peter Hibbs.