Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


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

27 Jan 2016   #1
BusinessAnalyst

Windows 7 64bit
 
 
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 System SpecsSystem Spec
.
27 Jan 2016   #2
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

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 System SpecsSystem Spec
27 Jan 2016   #3
BusinessAnalyst

Windows 7 64bit
 
 

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 System SpecsSystem Spec
.

27 Jan 2016   #4
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

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 System SpecsSystem Spec
28 Jan 2016   #5
BusinessAnalyst

Windows 7 64bit
 
 

This was helpful.. thank you
My System SpecsSystem Spec
28 Jan 2016   #6
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

You are welcome & thanks for getting back.
My System SpecsSystem Spec
Reply

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




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Mysterious field display behavior in Outlook 2010
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...
Microsoft Office
Cyrillic chars instead of Western European
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...
General Discussion
Forms/Word 2007/Display entire field length
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...
Microsoft Office
must be more than 3 chars--error msg
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?". ...
Chillout Room


Our Sites

Site Links

About Us

Find 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 15:22.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App