Hello All,
I have an Access Front End System sitting on top of a SQl Database. There is a name search item in which the user selects a name from a combo box and clicks "Find". The combo box uses a queried name list, with the name built LastName, FirstName. The problem is that the combo box only lists up to the V's - no names past that. The query behind the combo box lists all names A thru Z, but still, the combo box only displays last names up to V. There are over 77,000 names - does Access limit the number of items in a combo box? Any work-arounds available? Thanks in advance!
I have an Access Front End System sitting on top of a SQl Database. There is a name search item in which the user selects a name from a combo box and clicks "Find". The combo box uses a queried name list, with the name built LastName, FirstName. The problem is that the combo box only lists up to the V's - no names past that. The query behind the combo box lists all names A thru Z, but still, the combo box only displays last names up to V. There are over 77,000 names - does Access limit the number of items in a combo box? Any work-arounds available? Thanks in advance!
