active count of string

I need to have a form which will give an active count of a string length I have one text box to type in and a second text box with this code =(140-len(TXT_MSG), but it will only count when the origional text loses focus, is there a way to have that count show for each character
Who is Participating?
Rey Obrero (Capricorn1)Commented:
use the change event of the textbox

private sub TXT_MSG_Change()

me.text2 = (140 - Len(TXT_MSG.Text))

end sub

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Try this:


smurfer69Author Commented:
That caused and error
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.