Hi guys, I face a small problem. How do i tell the computer to capture to accept anything that start with a 1xxxx in access? Can i use the format ?? Thks.

e.g.
With Adodc1

.Recordset.MoveFirst
While (Not .Recordset.EOF)
If Text9.Text = 1xxxx Then
.Recordset.UpdateBatch
.Recordset!ty = Val(Text10.Text)
.Recordset.Update
.Recordset.MoveNext
Adodc2.Recordset.MoveNext
Else
....