[AccessD] Really long memo fields

There is a 64K character limit on the content of a textbox so even if you store it, you can't 
display it.  (and a label is limited to 2048 characters).

There's a list of limitations here: http://www.databasedev.co.uk/access_specifications.html
(at least for A2K3).

I use Rusty's method in these situations.  A continuous form of separate comments each one 
date/time stamped. In many  cases I add another field as well, containing the logon name of 
the user creating the comment.  That way you can filter/sort all of that user content by creator 
and/or date time very easily.

-- 
Stuart



On 17 May 2010 at 18:03, Drew Wutka wrote:

> My first question is do you really have a user TYPING in 65k+ of text
> into one field?  Sheesh!
> 
> I do not believe there is anything special to add more than 65k to a
> memo field.  I believe you can just open a recordset, and set a memo
> field to whatever value you want, up to the size limit of the .mdb.  But
> I have never looked into whether or not there is a limit to the size of
> a textbox.
> 
> Here's a spec on the memo field:
> http://www.mvps.org/access/general/gen0011.htm
> 
> Drew
>