Clear input field value via macro

[#1]

Hi everyone,

i'm working on a QV where i have a simple table with an inputfield column.

I was wondering if smbdy would knew a VB or Java command to clear inputfield value, or force it to 0 for the active selection??

thanks for help

[#2]

Here is a sample code.

set fld = ActiveDocument.Fields("Budgetentry")

fld.ResetInputFieldValues 0

Hope that helps.

Philippe

[#3]

Hi thanks for the quik replys, however, i tried that but this one enable to restore the value of the input field, not to clear it or force it to 0.

[#4]

I am using that macro to reset a straight table with inputsum cells in it . And it resets it to 0.

Philippe

[#5]

Try it with this file:

Input.zip

There is a sample like Phillipe mentioned.

Kind regards,

Björn

[#6]

Well, i see now why this command doesn't work for me!!

Actually, my inputfield takes his values from an Xls file (to avoid losses of values, due to the inputfield issue: when adding some lines, the input field keeps it position and does not work as it should! i guess you understand what i m talking about.), and when i execute the macro, it takes the last known value since last reload and does not force it to zero as it work in your example when their is no source for this inputfield.

So because of that, i can't find any good command to force my input field value to be 0. any ideas?

[#7]

Hi,

Could u plz tell me how to reset the input fields on pressing Clear on the toolbar

Thanks

[Anonymous]

hi TheSariP

     Hope the following macro attached qv file will be helpful for your problem

Regards

Ashok

[Anonymous]

Hi qlik_techie,

     Hope the above attached file will be give some idea to reset your input field using macro

     Regards

Ashok