Validation Of Textboxes In A Form

Thanks mudraker, that codes works great.
Could you show me the code that would validate TextBox1 (Item name) so that something written in there is less than 50 characters but more than 0. Thanks a lot, a quick reply would be much appreciated.

Thanks, Ben.

Ben

If you use the MaxLength property set to 50 then you cane use

If TextBox.Text = vbNullString Then
   MsgBox "Invalid Entry", vbInformation
   Exit Sub
end if

Otherwise use this one

Select Case Len(TextBox.Text)
Case Is < 1, Is >= 50
   MsgBox "Invalid Entry", vbInformation
   Exit Sub
End Select