<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=359113116-11042003>I upsized an
application from an Access FE / BE to an Access ADP FE / Sql Server 2000 BE.
</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=359113116-11042003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=359113116-11042003>A memo field for
Notes became a 'ntext' field in Sql Server.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=359113116-11042003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=359113116-11042003>A user is getting a
message 'The text is too long to be edited' when she clicks into the Notes field
in several records -- records with a lot of data stored in the Notes field. My
understanding is that the Sql Server 'ntext' field is limited only by
the storage of the server, so I'm guessing that the problem is with the Access
Adp FE. </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=359113116-11042003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=359113116-11042003>Does an
Access Adp textbox have a limit on the amount of data it can
hold?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=359113116-11042003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=359113116-11042003>All suggestions
welcome.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=359113116-11042003><FONT face=Arial
size=2>TIA,</FONT></SPAN></DIV>
<DIV><SPAN class=359113116-11042003><FONT face=Arial
size=2>Myke</FONT></SPAN></DIV></BODY></HTML>