Validation Rule

[Guest]

Hallo

I hope some one can help me I want to validate the first 5 characters of a
text box with the a different text box. If they match that its ok if not I
want a msgbox to give me a error but only the first 5 have to be the same

Regards
Markus

 

[Stefan Hoffmann]

hi Markus,

I hope some one can help me I want to validate the first 5 characters of a
text box with the a different text box. If they match that its ok if not I
want a msgbox to give me a error but only the first 5 have to be the same

If Len(DifferentTextBox.Value) > 4 Then
If Len(TextBox.Value) < 5 Then
MsgBox "No match, to few characters."
Else
If Left(TextBox.Value, 5) = Left(DifferentTextBox.Value, 5) Then
MsgBox "Yeah, match."
Else
MsgBox "Uh, no match."
End If
End If
Else
MsgBox "Cannot match against DTB, to few characters."
End If


mfG
--> stefan <--

 

[Guest]

Thank you it works

hi Markus,


If Len(DifferentTextBox.Value) > 4 Then
If Len(TextBox.Value) < 5 Then
MsgBox "No match, to few characters."
Else
If Left(TextBox.Value, 5) = Left(DifferentTextBox.Value, 5) Then
MsgBox "Yeah, match."
Else
MsgBox "Uh, no match."
End If
End If
Else
MsgBox "Cannot match against DTB, to few characters."
End If


mfG
--> stefan <--