>>>Add a CHR(10) where you want a line break to appear
>
>chr(13) did the trick!
>
>>If you just want to let the messagebox() wrap the line, make sure you put either a trailing space at the end of each part of the text, or a leading space at the beginning of the next part of the text: 'this is a test with trailing space ' + 'of this' or 'Another test' + ' of this with leading space.' These are just the rules for concatenating any string...
>>
>
>now thats how I did try it and that doesn't seem to work. But I've now globally replaced with the chr(13)s and its doing the job so I'm happy enuff with that.
>
>Thanks
>
>
>Harry

Glad to help.

Rob