Can you display more than 255 chars on a query report memo field?


  1. BusinessAnalyst
    Posts : 4
    Windows 7 64bit
       New #1

    Can you display more than 255 chars on a query report memo field?


    Hello,

    I have a problem with an access database report I am working on. how do I get the memo field of the report to show more than 255 characters? The data is there in the table but when I try to run the report, it cuts off or truncates the data after 255 characters. I went into the query and "ungrouped" the fields which worked to display all the data in the table, but now the query report won't display it all.... any ideas on how to remedy this?

    ---- Business Analyst
      My Computer
    Quote Quote

  3. Ranger4
    Posts : 9,746
    Windows 7 Home Premium 64 bit sp1
       New #2

    Hi & welcome to the Forum.

    This reply is a copy of what I put in your other Post on this matter.

    What version of Access are you using?. In Access 2013 the Memo field has been changed to Long Text, but Short Text has the same limitations as before of 255 characters.

    So check to see if you have the field set for Long Text. You need to do that to the main Table in Design View & that should change all related Queries etc. that relate to that Table.
      My Computer
    Quote Quote

  4. BusinessAnalyst
    Posts : 4
    Windows 7 64bit
    Thread Starter
       New #3

    I am using Access 2010....

    I was able to troubleshoot and may have found a work around. If I use the input table in the report as opposed to the table in which I am querying from, all the data shows. So it is when I run it through the query is when it truncates the data. With my work around, the only problem now is to find a way to filter on that report so it only shows the data set I am looking for. In some instances, it can be multiple lines, so I am unsure if this will work just yet...
      My Computer
    Quote Quote

  6. Ranger4
    Posts : 9,746
    Windows 7 Home Premium 64 bit sp1
       New #4

    This MS website might be of help to you on Access 2010 & Memo fields.

    https://support.office.com/en-US/art...7-C2BB6283535A

    There is more info here as well.

    Microsoft Access tips: Truncation of Memo fields
      My Computer
    Quote Quote

  7. BusinessAnalyst
    Posts : 4
    Windows 7 64bit
    Thread Starter
       New #5

    This was helpful.. thank you
      My Computer
    Quote Quote

  8. Ranger4
    Posts : 9,746
    Windows 7 Home Premium 64 bit sp1
       New #6

    You are welcome & thanks for getting back.
      My Computer
    Quote Quote

 

  Related Discussions
I have a three screen setup, two of the screens connect directly to the PC. The third connects to my receiver and that receiver connects to my computer. If the receiver is on Windows detects the monitor if the receiver is off no connection is present. Here is my issue: My icons get all messed up...
I recently had to reinstall Outlook 2010 on my Win7 Pro x64 system. After pointing the app to my old .pst file I noticed a number of fields now appear empty on the left of a contact form but still display their previous content in the summary window (don't know the actual name) on the right (see...
Hi people of the sevenforums. I'm sorry for this being my first post but I'm having a problem that's been giving me an headache for about 4 days now. Well it seems that all of a sudden my computer started showing cyrillic chars (they seem to be russian) in place of letters with special chars like...
Have created some basic online forms. Now I am tasked with displaying each entire field length (visually somehow) so the user can see approximately how much room they have to enter test. Examples: Name: Field length highlighted or shaded Location: Underlining would work to indicate field length...
OK guys, What am I doing wrong? When I try to use firefox to post a msg, i get-after hitting the submit button-a message about the message must be longer than 3 characters. I am NOT a fan of IE, but I'm forced to use IE to post/reply to messages here until I find out "what's up doc?". ...
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 20:28.
Find Us