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

Expand all | Collapse all

SUMMARY

To refer to a control's current value during a Change event, you can use the control's Text property.
Back to the top | Give Feedback

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.
Back to the top | Give Feedback

REFERENCES

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.
Back to the top | Give Feedback

Properties

Article ID: 209070 - Last Review: June 23, 2005 - Revision: 3.0
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbhowto kbinfo KB209070
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top