How to verify blank form fields on exit?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

charlie6067 - 05 Oct 2006 18:05 GMT

For example, a protected form has three fields: FName, Initial, and
LName. I need help writing an On Exit macro for the LName field that:

1. Reviews all form fields for blanks.
2. Displays the name of the blank form field(s) so user can correct.

I've tried using bits of code from other postings but can't seem to get
anything to work.

Thanks,
Charlie
charlie6067

Reply to this Message

Jay Freedman - 05 Oct 2006 19:19 GMT

Instead of one check on exit from the last field, I'd recommend a separate
validation for each field. The reason is that the user could use the mouse
to leave the FName or Initial field without ever going into the LName field,
and then no validation would be done.

You can use the macro in
http://www.word.mvps.org/FAQs/TblsFldsFms/ValidateFFields.htm as a basis.
Change the If statement to

If Len(Trim(.Result)) = 0 Then

to check for a field that's empty or contains only blank characters.

Signature

Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> For example, a protected form has three fields: FName, Initial, and
> LName. I need help writing an On Exit macro for the LName field that:
[quoted text clipped - 8 lines]
> Charlie
> charlie6067

Reply to this Message

charlie6067 - 05 Oct 2006 20:55 GMT

Thanks Jay - that worked. Yes, it is better to alert the user right
after the error instead at the end of the form. I appreciated the code.

Charlie
charlie6067

> Instead of one check on exit from the last field, I'd recommend a separate
> validation for each field. The reason is that the user could use the mouse
[quoted text clipped - 28 lines]
> > Charlie
> > charlie6067

Reply to this Message