[AccessD] Padding text values

Hi Susan

Yes, but you didn't use it in the AfterUpdate event, so what did it do for you?
As Stuart told, you cannot format a text that way using the Format property ...

/gustav

>>> harkinsss at bellsouth.net 17-01-2006 16:28 >>>
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