New to Msg Board - Auto Refreshing a counter field

  • Thread starter Thread starter gmanmtz
  • Start date Start date
G

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.
 
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"?
Click to expand...

Requery the count in the Change event of Comments:

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

John W. Vinson[MVP]
 
Back
Top