how to limit a multibox to be single selectable

[sonikajain]

Dear all,

Please advise on changing a mulitbox such that only one value is selectable at a time.

Sonika

[#2]

hi,

Go
properties / presentation

DropDown limit flag (1)

[sonikajain]

thanks for the reply, but still am bale to select multiple options

[#4]

there's an option in the presentation tab which is 'always one selected value'

[jagan]

Hi,

First select one value in the multi listbox, and then

Chart Properties -> Presentation -> Select Dimension -> Select "Always One Selected value"

Hope this helps you.

Hope attached image helps you.

Regards,

Jagan.

[#6]

This option is always disabled.

And moreover, when I have a expression based field to be displayed in multibox. I am not able to find/choose the same in the presentation tab under fields. Only option available to click and choose is -Closed Multi Box-, but not the expression.

[#7]

hi

1. Click tools and Edit module and place this code

sub ForceOneWeekend

SET Week_Ending_field = ActiveDocument.Fields("Week_Ending")

SET Week_Ending_values = Week_Ending_field.GetSelectedValues

if Week_Ending_values.count>0 then

ChosenValue = Week_Ending_values(0).Text '

Select the first / lowest

Week_Ending_field

.clear

Week_Ending_field

.Select ChosenValue

end if

end

sub

2. Make sure you change the field name to what your field name is

3. Settings>>>Document Properties>>>Triggers>>>Field event Trigger area and select your field name

4. add on select action

5. to run macro and call this macro that you added above..

works like a charm... good for list boxes etc as well..

Thanks

Faiq