Hi, I glossed over this message when I first read it.
However on second thought it may be worth considering. 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? Regards, Kelvin Eldridge Online Connections Website: www.onlineconnections.com.au Every day we solve and document clients problems. We now have over 1,400 documented solutions. Save time and money by checking the MyAnswers service. Your problem may have already been solved. www.onlineconnections.com.au/myanswers > -----Original Message----- > From: Frank Schönheit - Sun Microsystems Germany > [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 8 November 2005 10:31 PM > To: [email protected] > Subject: Re: [dba-users] how to make multiselection works? > > Hi Budi, > > > I have problems with this multiselection listbox. > > Here are what I did: > > create listbox with sql statement, change its control property: > > dropdown to no and multiselection to yes. the field type > for storing > > the value selected is text(varchar). > > The enlightening comment in the source code is this one here: > http://ooo.ximian.com/lxr/source/gsl/forms/source/component/Li > stBox.cxx#1116 > > In short: Exactly because it's not clear how to store the > "selection" in the bound database field, multi selection is > normally disabled for bound list boxes. > > Ciao > Frank > > -- > - Frank Schönheit, Software Engineer > [EMAIL PROTECTED] - > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
