Solved

Memo field truncated by insert query

Posted on 2008-10-20
3
378 Views
Last Modified: 2008-11-16
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
Comment
Question by:elschott
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 22762376
0
 
LVL 44

Expert Comment

by:GRayL
ID: 22762630
After - INSERT INTO referrals - you need a list of fields from Referrrals wrapped in parentheses.  Where did you get that format??
0
 

Author Comment

by:elschott
ID: 22762857
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

635 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question