Apache OpenOffice Community Forum

Form field > select it to get green boxes around > Control > General > scroll down > 'Multiselection' option : what is the meaning?

Which type of control it works?

If the form field is a 'Listbox', I can select multiple data?

thnx

You can not bind a list box to multiple values in the same field. This may be useful for programmers. Until now I have never used a multi-selection list box.

Villeroy wrote:You can not bind a list box to multiple values in the same field. This may be useful for programmers. Until now I have never used a multi-selection list box.

I agree that "You can not bind a list box to multiple values in the same field." But, how on earth can the multiselection be "useful for programmers"? Why does the OO Wiki say "If the MultiSelection property is set to True, more than one entry can be selected. " if it does not work?

You can select multiple values but only one field in one record can be written to the database backend. Did you try to bind a a multi box to a database field? If Base would be more developed, it would be thinkable to bind a multi-box to an array field but this is not the case. Base can not handle any array fields at all.

papijo wrote:how... can the multiselection be "useful for programmers"?

A macro could read the multiple selections out of the list box and write them or use them wherever the programmer wanted.

so then which is the purpose of multi-select in base forms listbox ? or... is there a way to use it ?

One common use that comes to mind would be to select a few items from the list and press a button to display a list properties for each of the selected items for comparison.

so in base forms cant i use it ?

You can use it anywhere you can.

in base forms with the multiselection enabled, and using the control, i am unable to do multiple selections on a listbox, what am i missing ?

A list box puts one value into its linked field.

so it is a design limitation ?
ok, but surely we can do some trick from basic and when detect two selected items show some msgbox or some.... otherwise we have that feature unuseful.

YOU are the programmer. It is YOUR obligation to collect an array of values from your control element and do what you want with it.

myself wrote:You can not bind a list box to multiple values in the same field. This may be useful for programmers. Until now I have never used a multi-selection list box.

Here is an example of how the Multiselection might be used. It is based on the stand alone form the Villeroy posted earlier.