Here is a snippet of code I use... see if this helps at all...
Dim lng As Integer
lng = Len(Src)
If lng > sz Then
Pad = ""
msg = "String's length exceeds padding size request in Function Pad()." & _
vbCr & "String:" & vbCr & Src & vbCr & "Length = " & lng & vbCr & _
"Padding size request = " & sz & "."
MsgBox msg, , "ADRAS"
Exit Function
End If