Is it possible to have on a form something that will prompt the user entering if the number of characters within a field is less than 10, is so then pop a message to say
Private Sub textbox1_BeforeUpdate(Cancel As Integer)
Dim i As Integer
i = Len(Me!textbox1 & "")
If i <> 0 Then
Cancel = i < 10
End if
If Cancel Then
Msgbox "Minimum length of string should be 10 characters!"
End If
End Sub
Is it possible to have on a form something that will prompt the user entering if the number of characters within a field is less than 10, is so then pop a message to say