Change a field by changing a other (1 Viewer)

[Reflex_ht]

Hy,

I use this code to calculate the length of a SMS message.

Me.Txtlange = Len(Nz(Me.SMStxt, 0))

But what event should I take to calculate it in real time when the user tipes in the message?

I tried afterupdate, on change and other but it just calculates the lenght when the user press enter or go to an other field

Is there an event for this?

I also tried to make a row in the table that is a calculated. That also changes only after the enter or leaving the field

 

[MarkK]

You can use the change event, but a little feature there is that since the .Value of the control is not updated until AfterUpdate, instead you need to read the .Text property. See if that makes a difference.