Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 383
  • Last Modified:

Memo field truncated by insert query

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
0
elschott
Asked:
elschott
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
0
 
GRayLCommented:
After - INSERT INTO referrals - you need a list of fields from Referrrals wrapped in parentheses.  Where did you get that format??
0
 
elschottAuthor Commented:
Thanks DatabaseMX I had come accross the allenbrowne site in my research but as far as I can tell it doesn't apply to my query as I am not aggregating, I am not applying uniqueness via distinct etc, I have a format on the date field but I have tried removing this and it still does not work and am not using a union only working on one table or concatenation, so based on that I would assume my query should be ok?

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now