Solved

Determine changes in text boxes

Posted on 2002-03-10
6
123 Views
Last Modified: 2010-05-02
I have several text boxes on one form. How can I loop through each text box on the form and determine if there were any text changes. I only have 30 points to post.
0
Comment
Question by:Draner
6 Comments
 
LVL 1

Expert Comment

by:Neo78
ID: 6855214
Are the text boxes initially empty? or they already have some info in them?
0
 
LVL 49

Accepted Solution

by:
Ryan Chong earned 30 total points
ID: 6855265
Hi,

Initially copy the content of the TextBoxes' Value into their Tag (in Form_Load() event). When running the program, Check the Tag and Value, if different then this means user make some changes, or simply define use a variable (maybe True or False), make it True if the Change event of TextBoxes is fired.
0
 

Author Comment

by:Draner
ID: 6855602
Neo, the text boxes have info in them
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:Draner
ID: 6855612
Neo, the text boxes have info in them
0
 
LVL 22

Expert Comment

by:rspahitz
ID: 6855644
Couldn't you just add code directly into the Change event procedure?  Or do you want to handle all of them in one block/batch rather than as they change?
0
 
LVL 44

Expert Comment

by:Arthur_Wood
ID: 6855674
YOu could always set a Form level flag: blnTXTChange as Boolean

then, for each TextBox on the form, it the Change Event:

Private Sub ANYTEXTBOX_Change() ' for EACH TEXTBOX
   blnTXTChange = True
End Sub

then you can test blnTXTChange and know if ANY Textbox had a change to its value.

Hope this is clear.

Artur Wood
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

895 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now