I using Access 2013. I have a long text field (Replaces the Memo field of Access 2010). I can put in in excess of 255 characters, but my report output trucates it at 255. How do I lengthen the field characteristics to print the complete data in that field?
Code:
SELECT Chng_ReqQry.CR_ID, Chng_ReqQry.CR_Numbers, Chng_ReqQry.Levels, IIf(([Sub_No]=0),Format([Date_ID],"dd mmm yy"),"") AS Date_IDs, Chng_ReqQry.Status, Chng_ReqQry.Change_Type, Chng_ReqQry.[HB Vers], Chng_ReqQry.Units, Chng_ReqQry.[MTOE Paras], Chng_ReqQry.People, Chng_ReqQry.[Change Requested], Chng_ReqQry.NOTES, Chng_ReqQry.Action_Items, Chng_ReqQry.Rationale, Chng_ReqQry.Action_Complete, Chng_ReqQry.NIE, Chng_ReqQry.AO_Vote, Chng_ReqQry.Hr
FROM Chng_ReqQry
WHERE (((Chng_ReqQry.[Change Requested])<>"Do not delete") AND ((Chng_ReqQry.Action_Complete)=False))
ORDER BY Chng_ReqQry.CR_ID, Chng_ReqQry.Levels DESC;