Solved

Memo field truncated by insert query

Posted on 2008-10-20
3
371 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
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

757 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now