Truncated combobox

  • Thread starter Thread starter M-Rob
  • Start date Start date
M

M-Rob

Access 2000. I have a bound combo box on a bound form. The
combobox's rowsource is a pass-thru query.
When the form is loaded, the list of customer names is
truncated vertically. Names stop at "E's" and not
the "Z's". Any idea of bugs or # of records limitations?

Thx
 
Hi,

I have found that in some cases the Combo Box control does not handle a
large number of rows.

You could try to limit the number of rows returned by having 2 Combo Boxes,
with the first having criteria that is used in the second.

HTH

--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/
 
Access 2000. I have a bound combo box on a bound form. The
combobox's rowsource is a pass-thru query.
When the form is loaded, the list of customer names is
truncated vertically. Names stop at "E's" and not
the "Z's". Any idea of bugs or # of records limitations?
Click to expand...

Try getting the .ListCount property of the combo box during the "OnGotFocus"
event. This will force the combo box to load all of the rows.
 
M-Rob said:
Access 2000. I have a bound combo box on a bound form. The
combobox's rowsource is a pass-thru query.
When the form is loaded, the list of customer names is
truncated vertically. Names stop at "E's" and not
the "Z's". Any idea of bugs or # of records limitations?
Click to expand...

How many names should the list contain? A combo box is limited to 65535
rows, or thereabouts. But that's *lot* of names -- more than it's
reasonable to expect a user to work through.

Is it possible that the query that should be loading the combo box is
timing out? What happens when you open the query directly as a
datasheet? Do you get all the names?
 
Back
Top