ACC: Using the Change Event to Display the Current Value

ID: Q114553

The information in this article applies to:

Microsoft Access versions 2.0, 7.0, 97

SUMMARY

Moderate: Requires basic macro, coding, and interoperability skills.

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

MORE INFORMATION

You can use a control's Text property to refer to the control's current value during a Change event. For example, 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 will be displayed in the title bar instead of the current value.

REFERENCES

For more information about the Change event, search the Help Index for "Change event," or ask the Microsoft Access 97 Office Assistant.

For more information about the OnChange property, search the Help Index for "OnChange property," or ask the Microsoft Access 97 Office Assistant.


Keywords          : FmsEvnt 
Version           : 2.0 7.0 97
Platform          : WINDOWS 
Issue type        : kbinfo

Last Reviewed: April 3, 1999