|
- Public Function IsLetterExist(strFld As String) As Boolean
- Dim bln As Boolean
- Dim i As Integer, j As Integer
- Dim intCode As Integer
- On Error GoTo IsLetterExist_Error
- bln = False
- If Not IsNull(strFld) Then
- i = Len(strFld)
- For j = 1 To i
- intCode = Asc(UCase(Mid(strFld, j, 1)))
- If 64 < intCode And intCode < 91 Then
- bln = True
- Exit For
- End If
- Next
- End If
- IsLetterExist = bln
- On Error GoTo 0
- Exit Function
- IsLetterExist_Error:
- MsgBox "Error " & Err.Number & " (" & Err.Description & ") "
- End Function
复制代码 |
|