Memo field truncating at 255 characters after pasting from excel

[ccondran08]

I have searched everywhere for this answer but still cant find anything for my situation. I have a very simple query which has 2 memo fields and is used in a subform and I copy and paste out of excel into these 2 fields (Description, Status). For some reason if I paste more than 255 characters into the memo field an error message will appear "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less date". After all the searching I have done I can only think that from the SQL code below it has something to do with the WHERE clause. Does anyone have any suggestions ? :banghead:


SELECT tbl_Actions.[Meeting_ID#], tbl_Actions.[Action_ID#], tbl_Actions.Type, tbl_Actions.Month_Ref, tbl_Actions.Meeting, tbl_Actions.[Organisation - 1], tbl_Actions.[Organisation - 2], tbl_Actions.[Date Raised], tbl_Actions.[Date Due], tbl_Actions.Maturity, tbl_Actions.Owner, tbl_Actions.Trend_Ref, tbl_Actions.Decision_Ref, tbl_Actions.Milestone_Ref, tbl_Actions.Description, tbl_Actions.Status, IIf(([Forms]![frm_Actions]![txt_Start_Date2]<=[Date Raised]) And ([Forms]![frm_Actions]![txt_End_Date2]>=[Date Raised]),1,0) AS [Counter]
FROM tbl_Actions
WHERE (((IIf([Forms]![frm_Actions]![chk_OpenActions]=False,"x",IIf(([Forms]![frm_Actions]![txtAccepted]=[Maturity]) Or ([Forms]![frm_Actions]![txtNew]=[Maturity]) Or [Forms]![frm_Actions]![txtPending]=[Maturity],"x")))="x") AND ((IIf([Forms]![frm_Actions]![chk_Overdue]=False,"x",IIf([Forms]![frm_Actions]![txtDataDate]>[Date Due] And ([Forms]![frm_Actions]![txtAccepted]=[Maturity]) Or ([Forms]![frm_Actions]![txtDataDate]>[Date Due]) And ([Forms]![frm_Actions]![txtNew]=[Maturity]) Or ([Forms]![frm_Actions]![txtDataDate]>[Date Due]) And ([Forms]![frm_Actions]![txtPending]=[Maturity]),"x")))="x") AND ((IIf([Forms]![frm_Actions]![cbo_Meeting] Is Null,"x",IIf([Forms]![frm_Actions]![cbo_Meeting]=[Meeting],"x")))="x") AND ((IIf([Forms]![frm_Actions]![cbrg1] Is Null,"x",IIf([Forms]![frm_Actions]![cbrg1]=[Organisation - 1],"x")))="x") AND ((IIf([Forms]![frm_Actions]![cbrg2] Is Null,"x",IIf([Forms]![frm_Actions]![cbrg2]=[Organisation - 2],"x")))="x") AND ((IIf([Forms]![frm_Actions]![cbo_Month_Ref] Is Null,"x",IIf([Forms]![frm_Actions]![cbo_Month_Ref]=[Month_Ref],"x")))="x") AND ((IIf([Forms]![frm_Actions]![cbo_Maturity] Is Null,"x",IIf([Forms]![frm_Actions]![cbo_Maturity]=[Maturity],"x")))="x") AND ((IIf([Forms]![frm_Actions]![txtSearch] Is Null,"x",IIf([Description] Like "*" & [Forms]![frm_Actions]![txtSearch] & "*","x")))="x") AND ((IIf([Forms]![frm_Actions]![txt_NameSearch] Is Null,"x",IIf([Owner] Like "*" & [Forms]![frm_Actions]![txt_NameSearch] & "*","x")))="x"));

 

[Ranman256]

create a table from the query.
if the memo field still retains all text, EXPORT (not paste) the data via
docmd.transferspreadsheet

this should not truncate any data.