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
Sandra
Who is Participating?
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.
=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.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
-
Course of the Month9 days, 23 hours left to enrollMonitoring and Operating a Private Cloud with System Center 2012 R2 273 lessons
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.