Ms-access – how to clear text box inside a macro


I have a macro for onclick event for a combo, how do i have something to clear the text box in the same form when the user click on combo box and make selection. I would like to do the clear inside the same macro rather than a procedure.

Best Solution

Not clear what you mean by macro? Do you mean the new macro language in Access, or do you mean VBA code?

In VBA code you can just go:

Me.MyComboBox = null

In macro code, you use SetProperty, input the name of your Control, set the Property to "Value" and just leave the Value blank.

enter image description here

Related Question