Validation not working

[EHS]

Hi there
I've have a form used to input/edit people data. The form has an exit/save button which performs various tasks via the click event. One of the tasks is calling a subroutine to validate some of the form's fields (subroutine attached). The UPN validation works (the first check), but none of the others. I placed msgbox statements before each of the ifs and they are being displayed, but the fields which should not be blank are being allowed through. Any ideas?

Thanks in advance

 

[John Big Booty]

If they are blank and your test for ZLS (Zero Length String) is not picking that up, then that would suggest that they hold a Null value rather than a ZLS, so to cover all bases aslo test for Null values using the IsNull() function

 

[EHS]

Thanks John! That did the trick.