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

Hale, Jim Jim.Hale at FleetPride.com
Mon Jun 5 13:05:39 CDT 2006


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


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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.


More information about the AccessD mailing list