Textbox .... event trigger / capture preliminary data before textbox info has been commited

Hi.

I am using Office 365  Microsoft Access (continuous form)

I have a textbox in the header section situated exactly above the related Access data field.

When that textbox has focus...............  When a user presses a key,   then I would like to detect this in some way.  My code needs to know what that textbox looks like at that moment so that I can do dynamic filtering on the related field.

My question.  How do I capture the current state of that textbox when the user has made a change to the textbox whilst still in the "edit mode".
peispudAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
try using the Change event of the textbox

private sub text0_change()
dim str as string
str = str & me.text0.text

msgbox str  ' to see the content of the textbox text0

end sub
0
 
peispudAuthor Commented:
Perfect!   Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.