select all in button action

[anuradhaa]

i want to select all in a field by clicking a button.

But don't know how to do that. please help me

Thanks

[kji]

Use the select "Select in Field" action, with the search string *.

[#3]

you have to create a button -> properties-> trigger -> selection in field -> select all

i attached a file for you where you can see what you have to do but watch out it is german 😉

regards,

MT

[anuradhaa]

here i have sales vales in feild, and in action button i need to select all sales. please help me

[#5]

Create a Button and set an Action as

Action-->Add-->Selection-->Select possible

and then Give Field as [Sales Values]

[anuradhaa]

there is no option called select all, could you please send me the exact english translation

[#7]

There is no such option called select all, the same can be done by "Select Possible" action as I posted above

[anuradhaa]

no there is a difference between those two options.

i have add select all option in selection box volume.

also add select possible in button.

i have created slider and variable.

so in my volume selection box i have set expression,

if(bbbbb <= VOLUME,VOLUME)

and bbbbb is a variable set in slider.

so once i select variable valuse selection box shows only volumes > selection variable val.

but the sheet doesn't change. one i click select all in selection box entire sheet change. but when i use select possible only volume selection box get selectted.

what i need is give button to users as "select all" once the select a value in slider, because they nee to see entire sheet based on there selection,

ex, when volume > 200

Thank You

[#9 · Accepted solution]

Hi,

You need to write the macro.

Follow the below steps:

1) Create a button object -->Properties --> Action --> add --> Run Macro. In Macro text box call macro name(Select_All). Paste the below macro in the macro edit module (Ctrl+M).

Sub Select_All

ActiveDocument.Fields("INV_STATUS").SelectAll

End Sub.

In the above macro INV_STATUS is my field name, Replace with field related to your project.

Find the attachment for sample example.

Thank you

[#10]

Hi Shrikant Koppad Sorry but Why to make it complex when it can be done without macro.

Johan Idh has already answered it correctly. Anuradha Abeysuriya I request you to close the thread if you have got the solution.