[dba-SQLServer] [AccessD] Rows limited in combo box

David Emerson newsgrps at dalyn.co.nz
Tue Oct 4 23:59:18 CDT 2005


Found it - Tools ... Options ... Advanced ... Client server settings 
... Default Max Records.  I set this to 0.

At 5/10/2005, you wrote:
>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
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list