ComboBox.OnChange 屬性 (Access)ComboBox.OnChange property (Access)

會設定或傳回其中一個物件套用至] 清單中的 [屬性] 視窗中的 [ On Change ] 方塊的值。Sets or returns the value of the On Change box in the Properties window of one of the objects in the Applies To list. 可讀寫的 StringRead/write String.



_運算式_代表**ComboBox** 物件的變數。expression A variable that represents a ComboBox object.


此屬性是很有用的以程式設計方式變更時觸發事件,Microsoft Access 所採取的動作。This property is helpful for programmatically changing the action that Microsoft Access takes when an event is triggered. 例如,在各個事件呼叫之間,您也許想要根據不同狀況下所引動的事件,來改變運算式的參數,或是從事件程序轉換到運算式或是巨集。For example, between event calls you may want to change an expression's parameters, or switch from an event procedure to an expression or macro, depending on the circumstances under which the event was triggered.

Change 事件發生於文字方塊的內容或文字部分下拉式方塊變更。The Change event occurs when the contents of a text box or the text portion of a combo box changes. 當您從索引標籤控制項中的某一頁移到另一頁時也會發生此事件。It also occurs when you move from one page to another page in a tab control.

OnChange值會是下列其中一個下列命令,根據 [選擇建立器] 視窗中 (藉由選擇方塊物件的 [屬性] 視窗中的On Change ] 旁的 [建立] 按鈕來存取):The OnChange value will be one of the following, depending on the selection chosen in the Choose Builder window (accessed by choosing the Build button next to the On Change box in the object's Properties window):

  • 如果您選擇 [運算式建立器],值會是 =運算式,其中_expression_是來自 [運算式建立器] 視窗的運算式。If you choose Expression Builder, the value will be =expression, where expression is the expression from the Expression Builder window.

  • 如果您選擇巨集建立器,值會是巨集的名稱。If you choose Macro Builder, the value is the name of the macro.

  • 如果您選擇程式碼建立器,值會是 [Event Procedure]。If you choose Code Builder, the value will be [Event Procedure].

如果 [On Change] 方塊是空白的,則此屬性值為空字串。If the On Change box is blank, the property value is an empty string.


下列範例列印在 [位址] 文字方塊中的即時運算] 視窗的OnChange屬性的值順序輸入表單上。The following example prints the value of the OnChange property in the Immediate window for the Address text box on the Order Entry form.

Debug.Print Forms("Order Entry").Controls("Address").OnChange

支援和意見反應Support and feedback

有關於 Office VBA 或這份文件的問題或意見反應嗎?Have questions or feedback about Office VBA or this documentation? 如需取得支援服務並提供意見反應的相關指導,請參閱 Office VBA 支援與意見反應Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.