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