Correction to Previous Left Pad.
Please correct before posting.
Function LeftPad( str_String As String, int_Length As Integer, str_Pad As
String ) As String
Dim int_add As Integer
int_add = int_length - Len(str_string)
' Default Pading
If Len(str_Pad) = 0 Then
str_Pad = " "
End If
If int_add <= 0 Then
LeftPad = str_string
Else
For x = 1 To int_add
LeftPad = str_Pad + LeftPad
Next
LeftPad = LeftPad + str_string
End If
End Function
This was first published in November 2000