Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
Course Of The Month
3 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
check all values of a row when leaving ACCESS 2003 form
Posted on 2013-01-07
Is there a simple way to check all the fields of a row when the user leaves no matter which field they are currently on in the row? That is, if a user clicks in field 3 of a row that has 10 fields, then when they exit that field, I want all the fields of that row validated. Is this possible?
Sandra
Sandra
[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
3 Comments
Active today
Why?
I assume this is for a continuous form?
Normally, you would only do this prior to updating the current record (Form_BeforeUpdate event), not when the user exits each field in the record.
It can be done, accomplished best by developing a function or subroutine and calling that from the LostFocus event of each control on your form, but I would recommend against it, as it can be very annoying to users.
They develop standard ways of doing things, and if they choose to click between controls on the form, they will not appreciate you forcing them to do things in a particular sequence.
I assume this is for a continuous form?
Normally, you would only do this prior to updating the current record (Form_BeforeUpdate event), not when the user exits each field in the record.
It can be done, accomplished best by developing a function or subroutine and calling that from the LostFocus event of each control on your form, but I would recommend against it, as it can be very annoying to users.
They develop standard ways of doing things, and if they choose to click between controls on the form, they will not appreciate you forcing them to do things in a particular sequence.
Yes, I want them to do things in a very particular sequence and I figured it would be a function call.
Active today
If you make it a function (rather than a subroutine), you can simply type:
=FunctionName()
in the "On Lost Focus" or "On Got Focus" event of the control in the Properties Dialog box. Actually, you could select all of the controls at once, and make a single entry as above and it will apply to all of the selected controls. BTW, the function would not have to return a value
If you are adamant that the steps be completed in a very specific sequence, I would recommend using the GotFocus event.
=FunctionName()
in the "On Lost Focus" or "On Got Focus" event of the control in the Properties Dialog box. Actually, you could select all of the controls at once, and make a single entry as above and it will apply to all of the selected controls. BTW, the function would not have to return a value
If you are adamant that the steps be completed in a very specific sequence, I would recommend using the GotFocus event.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
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.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month3 days, 11 hours left to enroll
Earn Certification
Managing Projects with Microsoft Project 2013 (Exam 74-343)
$49.00$44.10
Earn Certification
MCSA Configuring Windows 7 Exam 70-680
$49.00$44.10
630 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.