Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
ACC2000: Using the Change Event to Display the Current Value
Article ID: 209070 - View products that this article applies to.
This article was previously published under Q209070
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
To refer to a control's current value during a Change event, you can use the control's Text property.
Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. To display the current value of a field called "txtExample" in the title bar while you are typing in a text box bound to that field, create the following Change event procedure for the text box:
NOTE: You must use the Text property to refer to the text in the field before it is committed. In the above example, if
is used instead of
the committed value, not the current value, is displayed in the title bar.
For more information about the Change event, click Microsoft Access Help on the Help menu, type events and event properties reference in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
For more information about the OnChange property, click Microsoft Access Help on the Help menu, type event properties and objects they apply to in the Office Assistant or the Answer Wizard, and then click Search to view the topic.