oldvalue property length limits?

[mscertified]

I have a memo field being displayed in a large textbox. I have a need to
detect if any changes have been made. If I compare the value to the oldvalue,
will I run into any problems with the size of the field? Will the textbox and
the oldvalue property accept the full length allowed by a memo field?

 

[Marshall Barton]

I have a memo field being displayed in a large textbox. I have a need to
detect if any changes have been made. If I compare the value to the oldvalue,
will I run into any problems with the size of the field? Will the textbox and
the oldvalue property accept the full length allowed by a memo field?

Yes

Try it and verify it for yourself.

 

[missinglinq via AccessMonster.com]

Lengthwise, the thing you need to watch out for with memo fields are
functions that only take an integer for an argument. Frequently you'll see
someone ask how to make the cursor move to the end of the text on entering a
memo field. The common answer is to use code like this in the Enter or
GotFocus event of the control:

YourControl.SelStart = Len(YourControl)

This works fine until the length of the field exceeds 32767 characters, then
it bombs with an Error 6 Overflow because SelStart takes an integer, whose
limit is 32767. Since I use a lot of memo fields, I'm still trying to find
a work around for this!

 

[Stephen Lebans]

You should learn how to search using GoogleGroups:

lebans selstart memo integer

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[mscertified]

Yes, I have also hit that problem myself.