Feild too small issue!!!

[violentjay25]

I need help. I have a simple select query that I need to run. The problem is if one field has too much data in it I get the following error. "The field is to small to accept the amount of data you attemped to add. Try inserting or pasting less data." What is funny the data is already in tables in a SQL Database. ITS ALREADY IN THERE!!!!!!!What makes no sense is in this query 2 of the fields have more data than this paticualar field. Here is my code. Objective and SMERequrments have more data than LastOfMemo1. That is the field that seems to have a problem. I just dont get it. Access is such a piece of #%^&

SELECT tbl_Projects.ProjectName, tbl_Projects.SPRNum, tbl_Projects.ReleaseDate, tbl_Projects.Status, tbl_Projects.StakeHolder, tbl_Projects.IBR1, tbl_Projects.CSIPM, tbl_Projects.BPM, tbl_Projects.SystemsImpacted, tbl_Projects.Objective, tbl_Projects.SMERequirments, tbl_Projects.IBR2, tbl_Projects.IBR3, tbl_Projects.Implemented, tbl_Projects.Phase, qry_Memo_Last.MaxOfDate1, qry_Memo_Last.LastOfMemo1
FROM tbl_Projects LEFT JOIN qry_Memo_Last ON tbl_Projects.ProjectName = qry_Memo_Last.ProjectName;

 

[modest]

One of the fields of the table is too small... go back and check the field size in the table design view. It probably has to do with the join, don't forget to compact and repair the database.

 

[violentjay25]

I have checked

The fields are all the same length wih the exact same data in them. For some reason Memo1 does not like data with more than 250 chars. Im am totally baffeled

 

[modest]

don't know what to tell you... I would do a repair. What's the other query do?