Memo field Truncated by insert query

E

Edmund Rice

I have a memo field that when data is inserted via a query seems to be
getting truncated, whenever the text amount gets above 500 characters. I have
developed a form with a submit button when the user clicks the submit button
the following command call is executed.

DoCmd.OpenQuery ("Add_New_Referral")

The Add_New_Referral query has the following syntax

INSERT INTO referrals
VALUES (Forms!Add_New_Referral!ReferralNum, Forms!Add_New_Referral!StuNum,
Forms!Add_New_Referral!TeachCode, Forms!Add_New_Referral!Subject,
Format(Forms!Add_New_Referral!Date,"dd,mm,yyyy"),
Forms!Add_New_Referral!Description, Forms!Add_New_Referral!Apology,
Forms!Add_New_Referral!Letter, Forms!Add_New_Referral!Detention,
Forms!Add_New_Referral!YC, Forms!Add_New_Referral!Telephoned);

When the data is truncated the last few characters are displayed as
unprintable characters.

There is a little bit about this on the web but none of the solutions seemed
to work for me, does anyone have any suggestions

Thank You
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Table Query Truncating Memo Field at 255 Characters 1
disctinct query memo field 3
Multiple Parameter Crosstab query filter by form 1
Memo Field Truncated on Update from Form 1
UNION query results in memo column being truncated 2
insert memo feild into a memo field truncates at 255 characters - 4
QBF & Query Malfunction 0
Query field size quandry 2

Top