Avatar of Sandra Smith
Sandra Smith
Flag for United States of America asked on

check all values of a row when leaving ACCESS 2003 form

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
Microsoft ApplicationsMicrosoft DevelopmentMicrosoft Access

Avatar of undefined
Last Comment
Dale Fye

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Dale Fye

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Sandra Smith

ASKER
Yes, I want them to do things in a very particular sequence and I figured it would be a function call.
Dale Fye

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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck