Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

check all values of a row when leaving ACCESS 2003 form

Posted on 2013-01-07
3
Medium Priority
?
281 Views
Last Modified: 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
0
Comment
Question by:ssmith94015
  • 2
3 Comments
 
LVL 49

Accepted Solution

by:
Dale Fye earned 2000 total points
ID: 38751967
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.
0
 

Author Closing Comment

by:ssmith94015
ID: 38751987
Yes, I want them to do things in a very particular sequence and I figured it would be a function call.
0
 
LVL 49

Expert Comment

by:Dale Fye
ID: 38752039
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.
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

782 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