Solved

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

Posted on 2013-10-24
2
415 Views
Last Modified: 2013-10-25
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".
0
Comment
Question by:peispud
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 39599257
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
 

Author Closing Comment

by:peispud
ID: 39600191
Perfect!   Thank you.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question