Combobox not showing all values from rowsource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ricmart - 24 Jan 2006 23:41 GMT

Using Access 2003 ADP linked to SQL Server 2000. I have similar comboboxes
in a couple of forms. The rowsource for each combox is a simple select
statement on a table. When I open either form not all the values are listed
in the combox. The tables contain about 15,000 records each, but the combox
seem to list up to the 10,000 record. How can I make sure the combox has all
the values listed in it, so that when I start entering an item that starts
with an "s" for example the autocomplete feature will find the first item
that starts with an "S". I recently started using ADP so this is the first
time I run across this problem with a combox.
Thank you.

Reply to this Message

Sylvain Lafontaine - 25 Jan 2006 00:13 GMT

Try changing the default value for Default Max Records in the Advanced tab
of the Options window.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

> Using Access 2003 ADP linked to SQL Server 2000. I have similar
> comboboxes
[quoted text clipped - 11 lines]
> time I run across this problem with a combox.
> Thank you.

Reply to this Message

ricmart - 25 Jan 2006 21:46 GMT

Figures it would be something simple as that. I was under options looking
for something like that and If I remember correctly I did look under the
Advanced tab for something having to do with max records to show, but I
missed obviously.

Anyway, that works just great!!, thank you very much Mr. Lafontaine.

> Try changing the default value for Default Max Records in the Advanced tab
> of the Options window.
[quoted text clipped - 14 lines]
> > time I run across this problem with a combox.
> > Thank you.

Reply to this Message