[dba-SQLServer] Rows limited in combo box

David Emerson newsgrps at dalyn.co.nz
Tue Oct 4 22:21:59 CDT 2005


Cross posted to AccessD, AccessDSQL

Access XP, SQL2K

I have a combo box that uses the value in the control source to link 
to another table and show the description (a typical 2 column combo 
box with the first column width set to 0)

The sproc that is the row source for the combo box returns 16484 
rows.  Lately the box has been showing blank even though there is a 
valid link to a row in the row source.  When I limit the number of 
rows the missing text appears.  It seems that Access is limiting the 
number of rows that are being returned (similar to the Maximum 
Records property for a form).

Is there a similar field for a combo box/stored procedure that will 
limit the records returned?

Regards

David Emerson
Dalyn Software Ltd
999 Moonshine Rd, RD 1
Judgeford, Porirua
New Zealand 6006
Phone    0064 4 235-6782
Fax      0064 4 235-6783 




More information about the dba-SQLServer mailing list