Solved

check all values of a row when leaving ACCESS 2003 form

Posted on 2013-01-07
3
273 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 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 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 47

Expert Comment

by:Dale Fye (Access MVP)
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Turn off MS Access Default=0 for Numerics 6 26
Should I keep recordsets open? 3 24
SQL multicriteria from ONE textbox 32 43
Part 2 to aggregate query solved qtn 12 37
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
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 …
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…

809 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