Carriage return.....

[cady]

If I have a string that is 100 words(not characters)long, is there a way when that string (from a rich text box) is printed or emailed to determine where the carriage return will happen and that on the next line to add spaces before the rest of the string for an indention? Hope this makes sense.
Cady

Ok something like

Pos = Instr(stringname,vbCR,1)

Gives position of CR, do a left to Pos-1 to get the words etc before the CR, or Mid to get after the CR, there is probably a vbTab or a char you can chuck in to insert a tab for indenting

Hope it helps

[cady]

Thanks! I will give this a try.
Cady