Length of number in a variable

    Hello All


    I am writing code that looks at entered employee numbers, but what i need to do is make sure there are 5 numbers in the variable (Number) i.e 12160. i tried using the

    Code
    If Len(Number) <> 5 Then

    But all i get is 2 because number is defined as an integer.


    any idea's


    thank you
    Brian G.

    [SIZE="6"][FONT="Comic Sans MS"]Brain G.[/FONT][/SIZE] :loopain:

    Re: Length of number in a variable


    Once again Andy Pope is the Man!


    Thank You

    [SIZE="6"][FONT="Comic Sans MS"]Brain G.[/FONT][/SIZE] :loopain:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login