Dynamic Split and rebuild!!!! Can this be done

Hi need your help again.

I have a multiline textbox that holds an address ( i wanted seperate boxes for each line but...) it can hold any amount of lines say

1 could have:

123 the street
London
L10 3MN


2 could have:

123 the street
West hill
City
PostCode
Country


this then needs to be imported into a word doc via a bookmark.

if i just put it straight into the bookmark you get all the carridge returns but want the address to read

123 the street, West hill, City, Postcode, Country


is there any way of doing this dynamically so that it doesn't matter how many lines there are it will still show all the data????


please help this is one of the last things needed for my program

something like this then...

VB Code:

Dim strResult As String
        Dim x As Integer
        For x = TextBox1.Lines.GetLowerBound(0) To TextBox1.Lines.GetUpperBound(0)
            strResult += TextBox1.Lines(x) & ","
        Next
        MessageBox.Show(strResult)

ok will try that tomorrow (if now = 00:57 then bed end if) so going to bed now

sorry the data is held in a dataset column not in an actual textbox