Error No 5854 : String Parameter Too Long

[sachien]

Dear Friends,

I am using FIND & REPLACE feature of Word object in my application.

The value which I want to replace is coming from database.The problem is sometimes the value fetched from database is too long nad yhe program generates this error

5854
String Parameter Too Long

Following is the Code snippet from my programme

For Each styRange In oApp.ActiveDocument.StoryRanges
                With styRange.Find
                          .Text = "<<" & VSFlexGrid1.TextMatrix(0, c) & ">>"
                          .Replacement.Text = TextToReplace
                          .Forward = True
                          .Wrap = wdFindContinue
                          .Execute Replace:=wdReplaceAll
                          
                    End With
                    Next styRange

I think Replacemnet.Text is not able to hold a larger string.

Can any one help for this.

I m waiting for your replies friend.

Thanks
-Sachien

[westconn1]

you are right, on testing the max length for replacement.text is 255

change you macro to like this

With Selection.Find
                          .Text = "mytest"
                          .Replacement.Text = ""
                          .Forward = True
                          .Wrap = wdFindContinue
                          .Execute
                          
                    End With
                    Selection = yourstring

pete

[nandini_net_in]

What do u mean by Selection = yourstring..please explain...

[westconn1]

yourstring is a variable with the string you want to replace into the selection, there is no limit on the string length here (or if there is i don't know what it is, but much bigger than 255)

pete