[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