Information - signs left 1

[Mollethewizard]

I’ve got a textbox in a user form that are limited in max lenght to 200 signs. I would like to put a label in the form that informs the user form how many signs there are left when he enters text in the textbox. How can I accomplish that?

Christer

 

[Chance1234]

you could use the len function

so something like

int_characters_remaining = 200 - len(txt_mytextbox_name.value)

Filmmaker, gentleman and new english wordsmith

http://WWW.5YLAC.S5.COM

http://WWW.HOWTOBESPOOKY.CO.UK

 

[TonyJollans]

Hi Christer,

Not entirely sure what you are doing here, but you should be able to do it in the textbox change event ..

[COLOR=blue]Private Sub TextBox1_Change()
    Me.Label1.Caption = "You have " & 200 - Len(Me.TextBox1) & " signs left"
End Sub[/color]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[Chance1234]

final tip, be careful on the wording! i did something similiar a while back and i had a user call us and say that the database could only store another 100 characters and she had several pages of data to enter.



Filmmaker, gentleman and new english wordsmith

http://WWW.5YLAC.S5.COM

http://WWW.HOWTOBESPOOKY.CO.UK

 

[Nikita6003]

Hiya Christer

Ifd you're using textboxes on a UserForm you can use the .TextLength property as well. Stick this in the OnChange event of a textbox [tt]txtComments [/tt]to update a label called [tt]lblComments[/tt]:

Private Sub txtComments_Change()
    If Me.txtComments.TextLength < 200 Then
        Me.lblCommentsLength = "You have " & 200 - Me.txtComments.TextLength & " characters left"
    Else
        Beep
    End If
End Sub

HTH

Cheers
Nikki
Look, mommy, I'm flying!

 

[Mollethewizard]

Thank you all for your swift reply!

Tony asked what I was trying to do – even if you are aware that a textbox only can store 200 characters, how often have you not exceeded that limit whit the result – stop in the middle of the most important sentence in your message!

Therefore I would like the user to know while writing how many characters there are left before he hits the ceiling.

Christer