Text Field Limits in Access

[Meir Simcha Kogan]

I have an access application with a form containing a text box bound to a
field in sql server of the "NText" datatype.

When the text exceeds a certain very large amount of content (over 130,000
characters) I get an error when adding text to the text box "Text is Too
Long to be Edited".

It seems that MSAcess has its own built in limit that may not be taking into
account the much larger limit of a sql text type field... or does the text
type field have a limit?

--

 

[Meir Simcha Kogan]

So what alternatives are there to the textBox control?

--

130K characters?

IIRC, an Access Textbox can only handle 64K characters.

The Memo Field in Access (equivalent to Text in SQL) can have up to 2G
characters but if you use the TextBox to enter the Memo Field, you are
restricted to 64K characters.

--
HTH
Van T. Dinh
MVP (Access)

 

[Van T. Dinh]

130K characters?

IIRC, an Access Textbox can only handle 64K characters.

The Memo Field in Access (equivalent to Text in SQL) can have up to 2G
characters but if you use the TextBox to enter the Memo Field, you are
restricted to 64K characters.

 

[Van T. Dinh]

Sorry, no ideas as I never got anywhere near 64K. All of my Memo Fields are
short notes, generally 1 or 2K characters.