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

The scroll bar for the list box was hidden behind the scroll bar for the 
sub-form. So scrolling  the visible bar scrolled the whole sub-form 
instead of the list box.  All right?  (Let that be a warning to you.)


Rocky


Hale, Jim wrote:
> Ah, come on 'fess up
> Jim Hale
>
> -----Original Message-----
> From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
> Sent: Monday, June 05, 2006 1:02 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] [Fwd: Re: Strange List Box Behavior]
>
>
> 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