Validateing a txtbox from form

L

Lou

I have a form that has textbox txtAN after the cmbbutton is clicked I want to verify that the information in the txtAN box is 5 numbers. It has to be 5 number no more/no less and no alpha charecters. How do you make this check occure

If txtAN < 5 Then GoTo errmsgbx Else I started with this but this is not correct. Any help would be great thanks.
 
B

Bob Phillips

If Len(txtAN.Text) = 5 Then
For i = 1 to 5
If Not Isnumeric(Mid(txtAN.Text,i,1)) Then
Msgbox "Invalid"
eND iF
Next i
Else
MsgBox "Invalid"
End If

You could trap the input and only allow numbers and only allow 5.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Lou said:
I have a form that has textbox txtAN after the cmbbutton is clicked I want
Click to expand...
to verify that the information in the txtAN box is 5 numbers. It has to be 5
number no more/no less and no alpha charecters. How do you make this check
occure.
If txtAN < 5 Then GoTo errmsgbx Else I started with this but this is not
Click to expand...
correct. Any help would be great thanks.
 
Top