Microsoft KB Archive/209070

= ACC2000: Using the Change Event to Display the Current Value =

Article ID: 209070

Article Last Modified on 6/23/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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).



SUMMARY
To refer to a control's current value during a Change event, you can use the control's Text property.



MORE INFORMATION
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: Sub txtExample_Change Me.Caption = Me!txtExample.Text End Sub NOTE: You must use the Text property to refer to the text in the field before it is committed. In the above example, if Me!txtExample is used instead of Me!txtExample.Text the committed value, not the current value, is displayed in the title bar.

