Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

ACC2000: Using the Change Event to Display the Current Value


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

↑ Back to the top


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


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


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


Keywords: KB209070, kbinfo, kbhowto

↑ Back to the top

Article Info
Article ID : 209070
Revision : 3
Created on : 6/23/2005
Published on : 6/23/2005
Exists online : False
Views : 258