Link to home
Get AccessLog in
Avatar of Sandra Smith
Sandra SmithFlag 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
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of Sandra Smith

ASKER

Yes, I want them to do things in a very particular sequence and I figured it would be a function call.
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.