then后不要跟语句,写成这样 If rs.Fields("a").Value = Text1.Text Then MsgBox "ddfdf" flag = False Exit Do Else rs.MoveNext End If
If rs.Fields("a").Value = Text1.Text Then MsgBox "ddfdf" flag = False Exit Do Else rs.MoveNext End If改为: If trim(rs.Fields("a").Value) = trim(Text1.Text) Then MsgBox "ddfdf" flag = False Exit Do Else rs.MoveNext End If试试!!!!!!
If rs.Fields("a").Value = Text1.Text Then
MsgBox "ddfdf"
flag = False
Exit Do
Else
rs.MoveNext
End If
flag = False
Exit Do
Else
rs.MoveNext
End If改为:
If trim(rs.Fields("a").Value) = trim(Text1.Text) Then
MsgBox "ddfdf"
flag = False
Exit Do
Else
rs.MoveNext
End If试试!!!!!!