DWUTKA at marlow.com
DWUTKA at marlow.com
Mon Jun 5 13:12:21 CDT 2006
What version of Access? I've seen that happen before. What's happening is that when the listbox is being 'drawn', it is being given an incorrect value for the number of items in the listbox....then the items are being correctly added later. A requery/refresh on the listbox should fix the problem. Drew -----Original Message----- From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] Sent: Monday, June 05, 2006 12:54 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Strange List Box Behavior 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com