Hi,

As a result of an issue on the dba list where a user was trying to store the 
multiple selections of a list box into a field it was stated the multi 
selection is normally disabled for bound list boxes.

On reflecting I realised that this is something I have programmed around in MS 
Access on a number of occasions. As such I thought it may be worth raising.

The following is a copy of my suggestion on the dba list.

In MS Access I have on a number of occasions wanted the user to select from 
multiple values. So I present them with another form where they can select 
each of the items. I then put the result back into a single field using some 
delimiter.

Now if I can simply use a list box which allowed multiple selections which 
then put the result into a bound field using a delimiter of my choice, that 
may be very handy.

I can think of many users for such an approach. The good thing is it means no 
programming for end users creating their own forms.

It would also mean when the user displayed this record again the items would 
need to be obtained from the value of the bound field so they could be shown 
as being selected.

I thought this might be something worth thinking about instead of simply 
sticking with the way we currently do things.

Why not have the multiple selection stored in a bound field?

Thanks

Kelvin