Is it possible to retrict users to enter only 11 digits, no spaces and - in txt boxes

[hansup]

I didn't put a NULL check in the function for sPhone. My understanding is that you would do that before calling the ValidatePhone routine.

A Null check in the function would be pointless. That function will never accept Null for sPhone because you declared it as String. And Null is not a String value. It would give you run-time error 94, Invalid use of Null

[VBA]Function ValidatePhone(sPhone As String) As String[/VBA]