New to Msg Board - Auto Refreshing a counter field

[gmanmtz]

Hi there,

First off, I've searched for the answer on the entire forum but did not find
the answer needed.

In a nutshell here it is. I have a comments section ( 255 characters max)
and I have a field that calculates the # of characters remaining i.e
"txtWordCount" using formula: = 255 - Len([Comments]), which works fine.

However, field "txtWordCount" only updates when I toggle out of the comments
field.

Is there vb code that could be put in to constantly update "txtWordCount"?

I've tried using the Me.Refresh but has not worked properly.

Any sugggestions are very much welcomed.

Thanks all.

 

[John Vinson]

However, field "txtWordCount" only updates when I toggle out of the comments
field.

Is there vb code that could be put in to constantly update "txtWordCount"?

Requery the count in the Change event of Comments:

Private Sub Comments_Change()
Me!txtWordCount.Requery
End Sub

John W. Vinson[MVP]