Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
Please advise on changing a mulitbox such that only one value is selectable at a time.
Sonika
hi,
Go
properties / presentation
DropDown limit flag (1)
thanks for the reply, but still am bale to select multiple options
there's an option in the presentation tab which is 'always one selected value'
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.
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.
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