"neowok " wrote in message
...
done some more testing and its now clear that the carriage return that
is in the oval is not the same as a 'vbnewline' so basically its not
picking it up, which is whats causing the error.

there must be another way to detect a return character other than
looking for vbnewline?

thanks


You can look for the specific character using its ascii code
typically 10 for CR or 13 for NewLine using the INSTR function

If Instr(0, SearchString, chr(10)) <0 Then
msgbox "New Line Found"
Endif

Keith