Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Friday 22 April 2016

How to allow to insert only Number in textbox in MsAcess form using VBA

 Use this function given below:
Public Function NumbersOnly(ByVal strText As String) As Boolean
    Dim intCounter As Integer
    For intCounter = 1 To Len(strText)
        If Not IsNumeric(Mid(strText, intCounter, 1)) Then
            NumbersOnly = False
            Exit Function
        End If
    Next intCounter
    NumbersOnly = True
End Function

No comments:

Post a Comment