Limited display in a combo box

  • Thread starter Thread starter Inma
  • Start date Start date
I

Inma

Hi,

I have a combo box linked to a SQL2K table's column (INT) which stores our
policies numbers. The numbers vary from 100 to 35000 and counting up.

What's happening in my case is that I cannot show (or pull) any number above
25634. The combo box acts as if numbers above 25634 do not exists in the
table.

Anyone knows why the combo box is limiting my search?

TIA

Inma
 
Assuming that you've got the Row Source for the combobox set to a query, do
you perhaps have the Max Records property set?
 
Hi Douglas,
Thank you for your replay.
The form had Max Records set to YES (I changed it to NO) and pushed to
100000 the max. number of record with no avail.
The problem seems to be within the combo box.
 
Does the query return all of the values?

The only limit I'm aware of for comboboxes is 65,535 rows. Of course, that's
about 100 times as many entries as you should be presenting to a user
anyhow, so it shouldn't be a problem.
 
I noticed that the problem is not with the combo box but with Access. When I
do a query listing the numbers of policies, I noticed that not all the data
is shown. But when the same query is used in SQL Entr. Manager, all the
data is shown. Can someone tell me why is this happening?
Thank you.
Inma
 
Hi,


Your options are probably limiting the number of records fetched from the
server. It is under the menu: Tools | Options ... | [ Advanced], 'Default
max records'




Hoping it may help,
Vanderghast, Access MVP
 
It sure did the trick!! Thank you.

Q: Why limit the number of record?
To control the bandwith/speed?

Michel Walsh said:
Hi,


Your options are probably limiting the number of records fetched from the
server. It is under the menu: Tools | Options ... | [ Advanced],
'Default max records'




Hoping it may help,
Vanderghast, Access MVP


Inma said:
I noticed that the problem is not with the combo box but with Access. When
I
do a query listing the numbers of policies, I noticed that not all the
data
is shown. But when the same query is used in SQL Entr. Manager, all the
data is shown. Can someone tell me why is this happening?
Thank you.
Inma
Click to expand...
Click to expand...
 
Hi,


Indeed. Also, browsing through too many records is not convenient, for the
end user... imagine your user scrolling through 1000s of lines. Even
spotting Canada in a list of 100+ countries (on many web pages) is not
necessary agreeable, imagine within 10 000+ entries... :-)


Vanderghast, Access MVP


Inma said:
It sure did the trick!! Thank you.

Q: Why limit the number of record?
To control the bandwith/speed?

Michel Walsh said:
Hi,


Your options are probably limiting the number of records fetched from the
server. It is under the menu: Tools | Options ... | [ Advanced],
'Default max records'




Hoping it may help,
Vanderghast, Access MVP


Inma said:
I noticed that the problem is not with the combo box but with Access.
When I
do a query listing the numbers of policies, I noticed that not all the
data
is shown. But when the same query is used in SQL Entr. Manager, all the
data is shown. Can someone tell me why is this happening?
Thank you.
Inma

"Inma" <[email protected]> escribió en el mensaje
Hi,

I have a combo box linked to a SQL2K table's column (INT) which stores
our
policies numbers. The numbers vary from 100 to 35000 and counting up.

What's happening in my case is that I cannot show (or pull) any number
above 25634. The combo box acts as if numbers above 25634 do not exists
in
the table.

Anyone knows why the combo box is limiting my search?

TIA

Inma
Click to expand...
Click to expand...
Click to expand...
 
Back
Top