I think this line gives you a little headach:
strPrint = Left(strPrint, Len(strPrint) - Len(vbNewLine))
Try using this instead:
VB Code:
If Right(strPrint, 2) = vbNewLine Then strPrint = Left(strPrint, Len(strPrint) - Len(vbNewLine)) End If 'OR strPrint = IIf(Right(strPrint, 2) = vbNewLine, Left(strPrint, Len(strPrint) - 2), strPrint)




Reply With Quote