Can't scroll down beyond the mid of an ACCESS table in a combo box

  • Thread starter Thread starter Jean Brasseur
  • Start date Start date
J

Jean Brasseur

Hello,

I have an ACCESS table with about 500 records.
When I open a form and try to select one of the record in
a combo box by dragging down quickly the cursor of the
scrollbar from the comb box; I can't go beyond the 200th
record. When I scroll down by clicking the down arrow of
the combo box, I can reach all records up to the last one
(500th), but it is very slow. After having reached the
last record once, I can drag up and down the cursor as
fast as I want. The same happens when instead of
clicking the down arrow to reach the last record I select
the last record by entering the value of the first indexed
column.

By the way can someone tell me how to scroll in a combo
box by using the mouse wheel . I have a office 2000
version.

Lot of tanks.

Jean
 
You cannot use the MouseWheel to scroll through the standard Access
ComboBox control.

A fix for you first issue is:

From: Stephen Lebans ([email protected])
Subject: Re: Combo scrolling
View this article only
Newsgroups: microsoft.public.access.formscoding
Date: 2001-12-19 10:08:48 PST


As John mentioned, it is a case of the Access GUI not knowing how many
rows will be returned by the Rowsource behind the control. To correct
this behaviour we need the force Access to evaluate the total number of
rows generated by the rowsource and then update the ScrollBar's
properties.

In the Form's Load event do something like this:
Dim lngCount as long
lngCount = Me.YourComboName.ListCount


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top