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.