ya i tried it now and it works thank u
and one more thing i am going to save this in ms access database before that i have to validate wheather each lines ended with comma or fullstop in that textbox because i have to cut the lines with less than or equal to 70 characters and it should be meaning full.
please help me to do this
I think this is going to be more complicated than you expect.
So far you have not done anything to the text. Setting the width of the textbox, and the font, only affects how it is shown on the screen - there are no "line breaks" in the text (you can demostrate this by using
Debug.Print to print the text to the immediate window). So it will be tough to work out where you want the commas or full stops.
It sounds as though you might have to independently re-create the word wrapping code, or something.