[AccessD] Multi-select listbox - Solved

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



More information about the AccessD mailing list