String length of a Variable

[Lamar]

If I assign a value to a variable (i.e. strNumber) then is there a way to
know the number of characters (or text length) in VBA.

i.e. strNumber = 1234, I want to be able know there is four characters (or
text length). if strNumber = 12, I want to know there is 2 characters.

Is there a function that will do that. Thank you.

 

[Jeff Boyce]

Lamar

Len(strNumber)

Regards

Jeff Boyce
Microsoft Office/Access MVP