[AccessD] Padding text values

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

>>> harkinsss at bellsouth.net 16-01-2006 22:57 >>>
Charlotte, Numeric fields are easy to pad -- in the Format property, you use
the 0 character for each character you want to force. I know that won't work
with a text field, but it just seems like I remember some kind of
expression/trick either in the Format or the Default property -- but I'm old
and I may be remembering something else. ;) 

Susan H.