Text Box Character Count

[mlr0911]

Hello All,


Does anyone know how to count the number of characters in a text box? What I am trying to accomplish is something like this (I have some code):


if me.text0=Len([text0].text)=9 then

me.text1.enabled=true

else

end if

However, I am not getting this to work. I have put it in the change event of the text box and the form.

Thanks in advance for your help.

 

[boblarson]

Try this instead:

If Len(Me.text0) = 9 then
Me.text1.Enabled = True
End If

You also don't need to put the Else in there if there isn't anything to go under it.

 

[mlr0911]

Thanks Boblarson it works.