Field Update Question

[Guest]

Hello. Normally, when entering data into a field, it doens't update until
you lose focus on that field. Is there a way to retrieve the value of a
field as characters are being entered instead of using the fieldname.value
property?

Thanks!

 

[Allen Browne]

If you are using a form, you can use the Text property of the control in its
Change event.

 

[Guest]

Can you explain? The change event doesn't seem to fire until you lose focus

 

[Allen Browne]

The Change event of the control fires with each keystroke.

Example:
Private Sub Text0_Change()
Debug.Print Me.Text0.Text
End Sub

 

[Guest]

How simple ... I wasn't aware that existed. Thanks!