Counting Characters in a string

[Les]

Is there an easy way to count the number of Characters in a string.

Thanks

Les

 

[Rick Brandt]

Is there an easy way to count the number of Characters in a string.

Len("YourString")

 

[Douglas J. Steele]

Just to clarify, Len("YourString") will return 9, since it's counting the
number of characters in the literal "YourString".

If you have a variable that contains the string value you want to check,
you'd use Len(nameofvariable)

 

[TC]

Where, of course, you would replace 'nameofvariable' with the name of your
own variable!

TC

 

[Les]

Thanks for that.

Les

Where, of course, you would replace 'nameofvariable' with the name of your
own variable!

TC

 

[PC Datasheet]

Just to be sure you get what you want, recognize that the Len function also
counts spaces.

Len("MyString") = 8
Len("My String") = 9

 

[Les]

Thanks
Good Point
Les

Just to be sure you get what you want, recognize that the Len function also
counts spaces.

Len("MyString") = 8
Len("My String") = 9

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

 

[TC]

Les, I think you now know all there is to know about the Len() function!

TC