Set cursor position in textbox results in overflow

[Sangeeta]

Hi,
Can some on help me with this. I am performing a find operation in a
textbox. I am using the selstart and sellenght function to highlight
the found words. I have read from other replies in google forms that
the selstart takes only integers. But i have a field that holds data
more than an intger can hold and need to make the cursor jump to that
word position. If the instr function found a word in a location that
integer value could hold it works fine. Otherwise it gives me an
overflow error.
Me.txtDisplayBox.SelStart = locfound - 1 'locfound in long
Me.txtDisplayBox.SelLength = strlen
Can someone suggest me a workaround on this issue!
How can i set the cursor to jump to a word which is in a position like
36045
Any help appreciated!
Thank you in advance

Sangeeta Noby

 

[ruralguy via AccessMonster.com]

This may be overkill but maybe?
http://www.lebans.com/richtext.htm

I'm not even sure it can handle SelStart > IntegerValue but it might be worth
a look/see. Stephan rarely lets you down.

 

[missinglinq via AccessMonster.com]

If this works please post back here! Myself and several others were trying to
solve this problem a few weeks ago. We were trying to use SelStart to set the
cursor to the end of text in a large memo field. Access will only set the
cursor to the integer's limit, which is 32,767 characters.