Tom,

As always - you came through AND so quickly!
Thank you!

My ignorance is showing as I used the following:

Private Sub TextBox54_BeforeUpdate(ByVal Cancel As
MSForms.ReturnBoolean)
Dim phn
phn = TextBox55
If Len(phn) < 7 Or Len(phn) < 10 Then _
Cancel = True

End Sub

wasn't sure how to use:
if "not validated" then _
Cancel = True

steve

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!