I have a Multi Box Object as
I am creating a button which on selecting should change the values in the Multi Box to A, B and C.
The usual way is
-Create an Action
-Select In Field
-Give the field name in Field
-Enter Search String in the Search String.
I am able to write ='A' in the Search String. How do I write multiple values in the Search String.
Solved! Go to Solution.
Can we use not to select one particular value and select the rest?
In this case, how can we select A,B,C but not D?
The reason am asking about excluding a value is because, if my options are too many, it's easier to exclude a single value rather than including too many values.
For example, if I have to select A to Y but not Z, easier would be excluding 'Z' rather than defining all 25 values.
I am creating a button and adding "Select in Field'' action. How do I define Search String here if I have to select alphabets A to Y but not Z in my Multi Box, when I click the button?
You are generating the Data using
LOAD Chr(ORD('A')+REcno()-1) as Char
This itself is selecting A to Y and excluding Z, right?
I need to create an Action in a button using 'Select in Field' so that when i click the button, A to Y values are selected, leaving 'Z'. This should happen after I select the button, not by default. I need to mention some logic in the 'Search String' field of Buttons->Actions->Select in Field->Search String