Strings question

[zeidhaddadin]

Hi all, I have a question..

Lets say I have a String which is called (String1).

charlen = Len(String1)
and c2 = 250 (how many chars i want to show from the String1)

I want it that If String1 is bigger than 250 to show the final word as complete like this:

welcome to my website

NOT

welcome to my webs (where s is the 250 character)...

I used this but it didn't work with me

	IF charlen > c2 Then
		For i = c2 To charlen
			IF Mid(String1, i, 1) = " " Then
				c2 = i
				EXIT For
			End IF
		NEXT
	End IF

[westconn1]

try this

IF charlen > c2 Then
        For i = c2 To charlen
            IF Mid(String1, i, 1) = " " And Len(Left(String1, i - 1) > charlen - 1 Then
                string2 =left(string1, i - 1)
                EXIT For
            End IF
        NEXT
    End IF