如何清除宏内的文本框? [英] how to clear text box inside a macro?

问题描述

我有一个组合的onclick事件宏，当用户单击组合框并进行选择时，我该如何用相同的形式清除文本框.我想在同一宏而不是过程中进行清除.

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.

推荐答案

不清楚您所说的宏是什么意思吗?您是在Access中指的是新的宏语言，还是VBA代码?

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

在VBA代码中，您可以执行以下操作:

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.

这篇关于如何清除宏内的文本框?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！