比較不錯一些表單驗證函數，大家可以參考下'*******************************************
'檢測是否只包含英文和數字
'*************************************
Function IsvalidValue(ArrayN, Str)
IsvalidValue = False
Dim GName
For Each GName in ArrayN
If Str = GName Then
IsvalidValue = True
Exit For
End If
Next
End Function
'*************************************
'檢測是否有效的數字
'*************************************
Function IsInteger(Para)
IsInteger = False
If Not (IsNull(Para) Or Trim(Para) = Or Not IsNumeric(Para)) Then
IsInteger = True
End If
End Function
'*************************************
'使用者名稱檢測
'*************************************
Function IsValidUserName(byVal UserName)
Dim i, c
Dim VUserName
IsValidUserName = True
For i = 1 To Len(UserName)
c = LCase(Mid(UserName, i, 1))
If InStr($!<>?#^%@~`&*();:+=' , c) > 0 Then
IsValidUserName = False
Exit Function
End If
Next
For Each VUserName in Register_UserName
If UserName = VUserName Then
IsValidUserName = False
Exit For
End If
Next
End Function
'*************************************
'檢測是否有效的E-mail位址
'*************************************
Function IsValidEmail(Email)
Dim names, Name, i, c
IsValidEmail = True
Names = Split(email, @)
If UBound(names) <> 1 Then
IsValidEmail = False
Exit Function
End If
For Each Name IN names
If Len(Name) <= 0 Then
IsValidEmail = False
Exit Function
End If
For i = 1 To Len(Name)
c = LCase(Mid(Name, i, 1))
If InStr(abcdefghijklmnopqrstuvwxyz_-., c) <= 0 And Not IsNumeric(c) Then
IsValidEmail = False
Exit Function
End If
Next
If Left(Name, 1) = . Or Right(Name, 1) = . Then
IsValidEmail = False
Exit Function
End If
Next
If InStr(names(1), .) <= 0 Then
IsValidEmail = False
Exit Function
End If
i = Len(names(1)) - InStrRev(names(1), .)
If i <> 2 And i <> 3 Then
IsValidEmail = False
Exit Function
End If
If InStr(email, ..) > 0 Then
IsValidEmail = False
End If
End Function