Text Box AfterUpdate Event Procedure

[bobski1]

I have a text box on a form called "Field1". After I enter the entire character string in Field1 and press the enter key, I would like to perform an afterupdate event procedure equivalent to the afterupdate event procedure that is available in Microsoft Access for text fields. Something like:

Sub Field1_AfterUpdate()

MsgBox "Field1 = " & Field1

End Sub

Does anyone have a procedure page that mimics the event procedures available in Microsoft Access for text box objects. Example: beforeupdate, afterupdate, on enter, etc..

Does anyone know how I might create an event procedure that is equivalent to Microsoft Access event procedure : afterupdate

 

[dglienna]

You would trap the KeyPress or KeyDown events of the textbox, and perform an action when you press #13 (Enter).

Build the string until the user hits enter, then call a sub

-David
2006 & 2007 Microsoft Most Valuable Professional (MVP)
2006 Dell Certified System Professional (CSP)

 

[mattKnight]

Or look into validation events

Take Care

Matt
If at first you don't succeed, skydiving is not for you.