character count for textbox 1

[jase2006]

Can any show me a way to create a display for counting the number of characters being entered into a textbox (real-time) on a form.

 

[Remou]

If you wish to show the count, set the Control Source for a textbox, called, for example, txtCount, to:

[tt]=Len(Trim([txtEnterText].[Text]))[/tt]

Add code to the Change event of txtEnterText:

[tt]Me.txtCount.Requery[/tt]

 

[jase2006]

Thanks Remou it works!! No wonder it was not working before, I was using the len() function in the module part instead of control source.

 

[jase2006]

Actually I've got another problem related to this. Is there a way to add spaces and return characters to the count?

 

[Remou]

Yes, get rid of the Trim function.

 

[jase2006]

Duh, I feel so slow today. Thanks again Remou!