In between developing on your client and publishing to the server, have you emptied the data model at all (perhaps to check in to source control). If you empty the data model (or you open without data) then these field level properties will be removed.
I get around this by applying a select trigger on opening the document then firing a macro to set the "One & only one" property value.
The problem was that, I used the Subfield function in the trigger to limit the user in selecting multiple values.
Because of that, multiple values were getting selected in the server. I guess, trigger was not working properly in the server.
But how do i limit the user from selecting more than one value?
I should not use "always only one value selected".
I dont want it to use because the user has to select the value from the listbox.
At the beginning, all the listboxes will be empty. then user will select the value based on his view of seeing the data. so if i can't use always only one value selected.
Can we do it with expression?
Because of triggers, it gave me the problem so.
Well, as far as I know you can only run a check that will provide a
warning to the user that they can only select 1 value (if they have
selected more than one).
Populate the list box
Use a trigger to select the "default" option
Run a macro that sets the property of the list box to one and only one
This will have issues also, in that you then cannot clear the value
because of the above property being set, but it might be worth a try to
see if re-populating the list box clears the property. Bear in mind that
in order to set the property of one and only one, you must have a value
selected already which is why I have said to select a default. If you
cannot select a default value in the list box then I'm afraid you're not
going to be able to do anything apart from issue a warning that more
than one value is selected.
if you have a chart associated with the listbox that you want to calculate, you want to add the restriction in the calculation condition under general tab.
something like count(distinct ([your fieldname])=1
I think that may solve your problem.
then in your help, you can say, only one selection is allowed.