Hello -
May be I have been staring at code a bit too long.
I have a two textboxes.
In one, the user may enter up to 189 characters. The second textbox acts as a "character reader." As the user types in textbox1, textbox2 subtracts the characters remaining and provides the user "on the fly" characters remaining readout:
This all works well. But, where I am finding trouble is when the user moves to the next record in the form. Textbox2 does not update. In other words, if record 1 has no characters in textbox1, textbox2 should read 189. If the user moves to record 2 and there are 10 characters in textbox1 then textbox2 should read 179 but it doesn't :banghead:
I can enter a simple formula in textbox2 and it works fine when I move through the records but then I lose the "on the fly" character counting.
Any help is very much appreciated. Thank you much!
May be I have been staring at code a bit too long.
I have a two textboxes.
In one, the user may enter up to 189 characters. The second textbox acts as a "character reader." As the user types in textbox1, textbox2 subtracts the characters remaining and provides the user "on the fly" characters remaining readout:
Code:
Private Sub Textbox1_Change()
Textbox2 = 189 - Len(Textbox1.Text) & " characters remaining."
End sub
I can enter a simple formula in textbox2 and it works fine when I move through the records but then I lose the "on the fly" character counting.
Any help is very much appreciated. Thank you much!