hello , im making a loop .... whenever i want to print the error it'll update my label , this mean it will print the last error record only...So how to print list of errors. Can anyone help me?I think using label is not suitable , what should i use then to print list of errors?

Do while not ts.AtTheEndOfStream
If Trim(Mfgno) = "" Then lbl2.Caption = "Error line=" & line
loop

Hi,

Make lbl2's Property MultiLine = True
and Change ur Code:

Do while not ts.AtTheEndOfStream
If Trim(Mfgno) = "" Then 
  lbl2.Caption = lbl2.Caption & " Error line=" & line
End If
loop

Regards
Veena