By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,870 Members | 2,347 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,870 IT Pros & Developers. It's quick & easy.

Truncated memo field

P: 2

I am using Access 2003.
I have an unbound form "SelectReview" with an unbound text box "txtLetterText" used to enter text for a memo field.

The table "MergeLetterText" contains the memo field "LetterText"

The text is truncated at around 500 characters - not the 255 characters I have read as a limit in other posts. It is then followed by several random characters

I have checked Allen Browne's site. None of the causes he lists seem to apply here. The memo field has no formatting in table or form.

The query used is a simple update query:
UPDATE MergeLetterText SET MergeLetterText.LetterText = [Forms]![SelectReview]![txtLetterText];

Can anyone suggest how to prevent the truncation.

I have already tried splitting the field into sections each of 255 characters but the truncation / garbage characters still occur when total character count reaches about 500.
Jul 21 '07 #1
Share this Question
Share on Google+
3 Replies

Expert 2.5K+
P: 3,072
I always use a tablefield of the Memo datatype placed on a form.
(Use an existing field or create a dummy one)
Place that field and make the field unbound afterwards.

Jul 21 '07 #2

P: 2
Thanks Nico

That did the trick!
Jul 21 '07 #3

Expert 2.5K+
P: 3,072
Glad I could help, success with your application !

Jul 21 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.