I have 2 text boxes. txtA allows a message to be typed in. txtB shows the number of characters in txtA. However, I want the value in txtB to update as each character is typed in (or deleted) much like an SMS message. The following code only updates the value in txtB on the first key press in txtA. Do I need to refresh txtB somehow?
Code:
Private Sub txtInvestigation_Change()
Me.txtCommentCount.Value = Len(Me.txtInvestigation)
End Sub