[AccessD] [Fwd: Re: Strange List Box Behavior]

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Mon Jun 5 13:01:57 CDT 2006


Never mind.  I did something so dumb I don't even want to talk about 
it.  Problem is fixed, though.

Rocky


-------- Original Message --------
Subject: 	Re: [AccessD] Strange List Box Behavior
Date: 	Mon, 05 Jun 2006 10:54:04 -0700
From: 	Rocky Smolin - Beach Access Software <bchacc at san.rr.com>
To: 	Access Developers discussion and problem solving 
<accessd at databaseadvisors.com>
References: 	<448446A0.4020003 at san.rr.com> 
<53c8e05a0606051034n7d631298yf280a9e774f632cf at mail.gmail.com>



Flash!  This just in...

All the records are there but the vertical scroll bar is not adjusting 
itself to accommodate all the records.  It will scroll down and show 
about 19 records.  But if I select a record and use the mouse scroll 
wheel or use the page down button, I see all the records.

The problem is the vertical slider bar not shrinking so that you can 
scroll all the records.

So now what?  I've never seen a vertical slider behave that way before.

Rocky


Josh McFarlane wrote:
> On 6/5/06, Rocky Smolin - Beach Access Software <bchacc at san.rr.com> wrote:
>   
>> Dear List:
>>
>> I have a list box hooked to a query with one filter.  The underlying
>> table for the query has 165 records.  With the filter the query returns
>> 142.  But the list box is only showing 19.  I put a msgbox
>> mylist.listcount which shows 142 records in the list box.  Thirteen
>> fields in the query, thirteen columns in the list box and thirteen
>> column widths.
>>
>> But the box only shows 19 records.
>>
>> I can't see any properties in the property box that might be limiting it.
>>
>> IS there something simple I'm overlooking?
>>     
>
> Is there anything in the code that changes the listbox sort and you
> might have forgot to refresh it afterwards?
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com


-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com




More information about the AccessD mailing list