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