[AccessD] Padding text values

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





More information about the AccessD mailing list