Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Memo field truncated by insert query

Posted on 2008-10-20
3
Medium Priority
?
380 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 1500 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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

705 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