Joe O'Connell
joeo at appoli.com
Tue May 29 17:31:00 CDT 2012
Andy, If the multi-select is the problem, could you 1) after user enters the search value, turn off multi-select, 2) set the list box Value property, 3) turn on multi-select? Joe O'Connell -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Tuesday, May 29, 2012 3:18 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Multi-select listbox - Solved ...a bit messy. Involves the .Recordset of the Listbox but only seems to work in A2010 (well, not A2000 anyway so in-between versions may be ok) and then not always. I'll post the best I can come up with once I've done with it. If anyone has a total solution I'd still be interested. Andy -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: 29 May 2012 16:18 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Multi-select listbox - Solved ...And the answer is.......? ;-) Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andrew Lacey Sent: Tuesday, May 29, 2012 8:05 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Multi-select listbox - Solved It's ok I've solved it myself Andy On 29 May 2012 at 14:46 Andrew Lacey <andy at minstersystems.co.uk> wrote: > Hey all, here's a rarity, an actual Access question. > > > > Given a multi-select listbox what I want to achieve is this: > > - user types a search value in a textbox > > - routine searches for the first occurrence of search value in the > list > > - that first occurrence is selected > > > > I have all of that working BUT if the first occurrence is above or > below what's visible on-screen the entry is selected but can't be seen > without scrolling. What I want to do is reposition the list so the > user can see the > entry that has been found and selected. I reckon if it wasn't multi-select > then setting the listbox's Value property would probably work but > that's no > use on a multi-select. Anyone know how to achieve this? > > > > Cheers > > > > Andy > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com