[AccessD] Really long memo fields

In situations like this where they will be adding more and more notes,
I've added a simple related table where they create a new record for
each new note entry.  I'll even add a date field for a timestamp of when
it's created.  Create a simple datasheet form with the new table as the
recordsource, then add the new form as a sub-form to your existing data
entry form.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie
Sent: Monday, May 17, 2010 4:32 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Really long memo fields

Well for the first time I have a user bumping against the 65K limit for
memo fields entered from a text box. I thought unbinding would take care
of the problem, but I seem to be jettisoning some of the memo anyhow on
update. I am putting it back in using appendchunk because these users
write novels worth of notes.

Is the appendchunk my mistake?  Is the text box itself what is
constrained?  Do I need something much more complicated to add new  
notes, keep the old ones and allow access to old notes over 65K?   
Better yet does anyone have an example?

Debbie

Sent from my iPhone
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************