Solved Macro to Clear Listbox

[justin0312]

I have a macro to clear my forms (cbo, txtbox). Recently, I added few listbox to my form and the clear button wont work. Anyone can advise?

My current macro is using runmenucommand > UndoRecord

 

[theDBguy]

Try assigning the null value to your listbox.

 

[The_Doc_Man]

Do the added listboxes have default selections defined? An UNDO would take effect but if there is a default, it would be re-asserted.

 

[arnelgp]

On macro Designer, make sure that you toggle "Show All Actions"

Add to your macro:

SetValue
Item: [listboxnameHere]
Expression: [listboxnameHere].[ItemData](0)

SetValue
Item: [listboxnameHere]
Expression: -1

 

[justin0312]

Try assigning the null value to your listbox.

How do I add a null value in the list box?

 

[justin0312]

Do the added listboxes have default selections defined? An UNDO would take effect but if there is a default, it would be re-asserted.

No there is no default selection defined

 

[justin0312]

On macro Designer, make sure that you toggle "Show All Actions"

Add to your macro:

SetValue
Item: [listboxnameHere]
Expression: [listboxnameHere].[ItemData](0)

SetValue
Item: [listboxnameHere]
Expression: -1

I tried and is not working. Maybe i do it wrongly. Do you have any image example?

 

[arnelgp]

test and check

 

[justin0312]

test and check

Edit: Thanks, is working already. I changed the multiple select from simple to extended. Not sure why after the change, then it works.