473,898 Members | 3,702 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

memo field in report truncating at 255 characters

4 New Member
I have a memo field in a report that is truncating at 255 characters. I've tried the following w/no success: 1. Grow/Shrink option is yes. 2. "Group By" changed to "first". 3. "Group by" changed to "last" 4. took out memo field, saved query, and reinserted memo field. nothing seems to be fixing this bug. Please help! any suggestions are greatly appreciated.
Jan 27 '07 #1
21 25518
jenkinsloveschicken
56 New Member
I have a memo field in a report that is truncating at 255 characters. I've tried the following w/no success: 1. Grow/Shrink option is yes. 2. "Group By" changed to "first". 3. "Group by" changed to "last" 4. took out memo field, saved query, and reinserted memo field. nothing seems to be fixing this bug. Please help! any suggestions are greatly appreciated.
Does the memo field display correcty in your table? If so, it may be the query itself that is the cause of the problem. Would you mind posting the query?
Jan 27 '07 #2
NeoPa
32,584 Recognized Expert Moderator MVP
Good for you JLC (I really can't write jenkinsloveschi cken every time can I :)).
It's always good to see Junior Members helping with answers. In this case I suspect the OP is having the problem as they are trying to display the item in a report. Reports don't have Memo controls. IE. They must be trying to display a Memo field using a TextBox - for which the maximum length is 255 characters.
You may also be on the right lines with the query though - I'm not sure that would support anything greater than 255 characters either.
Jan 27 '07 #3
Jenn
4 New Member
I think I finally figured it out. I did have a memo field (not text field). The memo field seems to display all characters on current information, but was not working for older data that was imported into access from excel. As long as my current info is displaying, it's not a big problem anymore. thanks so much for the advice & tips.
-Jenn


Good for you JLC (I really can't write jenkinsloveschi cken every time can I :)).
It's always good to see Junior Members helping with answers. In this case I suspect the OP is having the problem as they are trying to display the item in a report. Reports don't have Memo controls. IE. They must be trying to display a Memo field using a TextBox - for which the maximum length is 255 characters.
You may also be on the right lines with the query though - I'm not sure that would support anything greater than 255 characters either.
Jan 28 '07 #4
MMcCarthy
14,534 Recognized Expert Moderator MVP
I think I finally figured it out. I did have a memo field (not text field). The memo field seems to display all characters on current information, but was not working for older data that was imported into access from excel. As long as my current info is displaying, it's not a big problem anymore. thanks so much for the advice & tips.
-Jenn
At a guess I would say that the older data that was imported from excel has some illegal carriage return characters that access can't interpret. If you view the data in the table can you see some rectangle characters mixed in with the text?
Jan 28 '07 #5
missinglinq
3,532 Recognized Expert Specialist
I use a fair number of memo fields because of working in the healthcare field; we're big on Progress Notes and such. Because of this I'm always looking out for anything on the topic. The following is a distillation of things I've picked up over the past few years. To give you an idea, I keep it in a file titled MemoFieldAngst!

Crosstab queries, Summary queries, Union queries, and Queries that use Distinct or DistinctRow will all truncate a memo field to 255 characters so Access can perform the required functionality of eliminating duplicates.

Also, if you have specified a format in the field's Format property, this will often truncate the data as well.

If Unique Value Property is set to Yes, Access has to compare the values and therefore Memo Field values are truncated.

The bottom line is, if you use memo fields keep it simple! No fancy formatting and no fancy data manipulation!
Jan 28 '07 #6
NeoPa
32,584 Recognized Expert Moderator MVP
I think I finally figured it out. I did have a memo field (not text field). The memo field seems to display all characters on current information, but was not working for older data that was imported into access from excel. As long as my current info is displaying, it's not a big problem anymore. thanks so much for the advice & tips.
-Jenn
I was aware that you were using a Memo Field in your table. However, unless you know something I don't, there is no Memo Control in either a Report or a Form. IE. Assuming your first post was accurate and you were having this problem in a Report, you were trying to display a Memo Field via a TextBox Control, which has a limit of 255 characters.
I hope that clears up any confusion :)
Jan 28 '07 #7
NeoPa
32,584 Recognized Expert Moderator MVP
We're going to have to set up a The Wisdom of MissingLinq thread obviously. I went to stick the new post and add it to the Tutorials section, only to find it done already (Memo Fields in Access). I thought Memo Field Angst a better title, but hey...
Jan 28 '07 #8
MMcCarthy
14,534 Recognized Expert Moderator MVP
We're going to have to set up a The Wisdom of MissingLinq thread obviously. I went to stick the new post and add it to the Tutorials section, only to find it done already (Memo Fields in Access). I thought Memo Field Angst a better title, but hey...
Talk to me and I'll explain how I did it.
Jan 28 '07 #9
NeoPa
32,584 Recognized Expert Moderator MVP
I will, but you're not online atm - even in TSDN so not just the program StartUp missing ;)
Jan 29 '07 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

3
10221
by: GorDon | last post by:
Hi, I have a report based on a query. The query grabs a memo field from my main table, yet when I display the memo field in the report it truncates the memo field (the field needs to hold more than 255 characters). The table holds all the memo text, but the query seems to truncate the memo field to 255 chars? This seems like there should be a relatively easy fix, but I can't seem to find it.
2
7531
by: Chris | last post by:
I'm sure this is a very easy one if you know, but any help would be appreciated I have a field in my database which needs to be as long as poosible. in the help it says that a memo field is 4000 odd characters long, which would be about right. However my memo field does not remember any more than about 300 characters. Is there a box or something to tick to allow longer field lengths? thanks again
3
3044
by: John | last post by:
I have a field, data type Memo, in a job details table. I have a text box on a report which I need to print the contents of this field. My problem is that the text box will only display 255 characters. How can I get the report to print this field completely. Thanks for any help out there. John.
4
4110
by: Anna | last post by:
Hi all, I have a query in ASP.NET that selects text from a memo field in Access (among other things). The query appears to be truncating the text at 255 characters. I've done a little research on this and found some other Google Groups threads that were helpful, but I still don't have a solution. My query is rather complicated and uses a union, but not the keyword distinct. The query is displayed in a datagrid, and I don't know how I...
7
7934
by: midlothian | last post by:
Does using CStr on a memo field truncate it to 255 characters? Seems like this is happening with some data in my tables. Is there a way around this?
9
5744
by: RMC | last post by:
Hello, I'm looking for a way to parse/format a memo field within a report. The Access 2000 database (application) has an equipment table that holds a memo field. Within the report, the memo field is printed within the detailed area. The problem is, the apllication is not setup properly, thus the users are entering data within the memo field as: location1 1/1/2005 1/1/2006
4
2079
by: JerryB | last post by:
I'm having a problem w/MS Access truncating a memo field in a report at 256 characters. I'm using MS Access 2000. Any suggestions appreciated.
0
3089
NeoPa
by: NeoPa | last post by:
**********
2
6807
by: Teresa L | last post by:
I am using Access 2003. I have a memo field that I have put into a report. My problem is that the report will only show a specific amount of characters in the report. It does not display the entire field. I have checked the properties and they are set to memo so what is happening here? I think it is happening in more than one field but I have only been able to identify or replicate the problem in one field. Thanks
0
9993
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9841
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11265
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10858
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10949
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9662
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6077
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4706
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4296
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.