combo box size

  • Thread starter Thread starter sandy p
  • Start date Start date
S

sandy p

Do Access 2003 combo boxes have a size limit? I have
a "last Name" search field which has a combo box source
that is a query of a 95,000 record table. The combo box
displays only the first 65,000 records.
 
Sandy

95,000 records is WAY to many for a combo. Most interface gurus feel that
combos with more than a couple hundred records is too many. I have gotten
away with 1200-1500 records in a combo.

You need to start thinking about another way to do what you are doing. You
might consider changing the combo to a list box, adding a text box above it,
and using the text the user type in there to limit the rows returned on the
list box.

Ron W
 
Back
Top