How many characters???

[ghayman73]

I am trying to display how many characters are in a text field like so

name=grant

how many=5.

however i also need it to count the blank spaces.

name=grant hayman

how many=12 (not 11)

is this possible and how do i display it as a numerical value.

all help is appreciated.


Grant

 

[PaulF]

using the Length function

Len([ControlName])


PaulF

 

[ghayman73]

Thanks paul ive been looking at the Len() function but was unsure how to use it.

any pointers.

thanks grant

 

[TonyJollans]

Hi Grant,

The

Len

function will give you what you want ...

Text = "Grant Hayman"
MsgBox Len(Text)

 ' will display 12

Enjoy,
Tony

 

[ghayman73]

works a treat thanks