Results 1 to 2 of 2
  1. #1
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    839

    Expand reports truncated field


    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;

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    Queries can truncate the memo field. (thanks Microsoft)
    But reporting from the table wont. (idiots)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Truncated when exported to excel
    By memaxt in forum Import/Export Data
    Replies: 1
    Last Post: 09-05-2014, 12:58 AM
  2. Replies: 1
    Last Post: 02-22-2013, 09:39 PM
  3. Truncated field in my report
    By cvolkers in forum Reports
    Replies: 1
    Last Post: 03-08-2011, 12:11 AM
  4. Auto expand memo field vertically to fit text
    By grant.smalley in forum Forms
    Replies: 1
    Last Post: 02-04-2010, 05:54 PM
  5. Expand field horizontally
    By jonsuns7 in forum Reports
    Replies: 1
    Last Post: 10-15-2009, 04:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums