Susan Harkins
harkinsss at bellsouth.net
Tue Jan 17 09:28:01 CST 2006
Thanks Gustav -- I'm already using a Format() expression.
Like I said, I guess I'm just remembering something incorrectly.
Susan H.
Hi Susan
That something could be the AfterUpdate event of the control.
Insert here:
Dim varValue As Variant
With Me.ActiveControl
varValue = .Value
If Not IsNull(varValue) Then
.Value = Format(varValue, "000")
End If
End With
/gustav