473,320 Members | 1,810 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

memo field in report truncating at 255 characters

4
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 25414
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,556 Expert Mod 16PB
Good for you JLC (I really can't write jenkinsloveschicken 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
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 jenkinsloveschicken 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 Expert Mod 8TB
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 Expert 2GB
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,556 Expert Mod 16PB
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,556 Expert Mod 16PB
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 Expert Mod 8TB
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,556 Expert Mod 16PB
I will, but you're not online atm - even in TSDN so not just the program StartUp missing ;)
Jan 29 '07 #10
MMcCarthy
14,534 Expert Mod 8TB
I will, but you're not online atm - even in TSDN so not just the program StartUp missing ;)
My niece's 18th birthday. I took a break.
Jan 29 '07 #11
NeoPa
32,556 Expert Mod 16PB
I have a niece having an 18th next month. I'm a bouncer - lol.
Of course you're allowed a break. You can look forward to another one next year too :D
Jan 29 '07 #12
MMcCarthy
14,534 Expert Mod 8TB
I have a niece having an 18th next month. I'm a bouncer - lol.
Of course you're allowed a break. You can look forward to another one next year too :D
One a year, you're too generous and that's enough hijacking of this thread.
Jan 29 '07 #13
Thanks for this thread!

Although it didn't have a way around the problem if indeed you do need to use a complicated query, it gave me enough info to find a way, so I thought I'd post.

Just create a simple query for that notes field and a report for just that field and use that report as a subreport in your report that must have a complex query to run it.

For instance, I am creating Order reports, but there are notes on each order that were being trunacated, so I created a simple query with just OrderID and NotesText, then created a report for just the NotesText field (and allowed it to grow or shrink) and then back to my complicated (not really, just grouping) query/report and created a subreport with the OrderID linked to the subreport (also allowed to grow or shrink).

Works sweetly!

Hope that helps someone else googling for answers!

c.
Nov 7 '07 #14
NeoPa
32,556 Expert Mod 16PB
Thanks Cindy.
We always appreciate more answers in threads. Different approaches nearly always prove valuable, even when they're not right for the current problem. Most of our traffic is actually from people who find threads by searching generally and most answers prove helpful for someone :)
Nov 8 '07 #15
Ericks
74
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.
Choosing the option "First" instead of "Group by" in the Totals field is what I would do. The name of the field will now start with FirstOf when in datasheet view. Make sure you change this in the report.
Nov 8 '07 #16
I had a very similar but more confusing issue and since this was the closest match on a web search I thought I would post here to save others the pain and immense confusion.

Using Access 2003 which does allow more than 255 characters in text areas on both forms and reports I had a report which was not showing the FIRST 255 characters of a text column. The data was from a view based on a VARCHAR(2000) column in SQL server using linked tables. A few other tables and views were inner joined but none reference this column.

I copied the query from the record source to a new basic query just to eliminate that and still had the issue. Showing the contents of the linked view or a simple SELECT * showed everything.

So, Starting from scratch I slowly built up the query, testing at each new addition to see where the problem occurred.

It turns out it was the last thing for me to test. I had DISTINCT instead of DISTINCTROW and that was the source of everything.
May 20 '10 #17
OldBirdman
675 512MB
You all need more breaks :)
A textbox control will display more than 255 characters. This is true for both bound and unbound textboxes. If it could not, there would be no way to either enter or view a memo field from a form.
Of course, if a textbox is bound, but not to a memo field, the size of the table field will limit the size allowed in the control.
May 20 '10 #18
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.

Thanks! My problem disappear after editing the query: without "distinct" it works good.
Apr 6 '13 #19
GregHB
2
One of my team members just had this issue yesterday (6-9-14). Thanks, everyone, for this thread. After reviewing your comments, I was able to fix the issue with her query.

As it turns out, she had "Totals" enabled and that was causing her Notes (Memo) field to be truncated.

I could see the data in the tables. Calculated fields showed the data in plain text: "Left([Notes],64000)" Type = Memo / plain text (Type = Text resulted in truncated fields in the table). But, each time the query would run, the fields would be cut off at 255 characters; sometimes in mid-sentence, other times in mid-word.

Sorry if I've revived a long-dormant thread, but this was extremely helpful to me and my team. We were able to publish a complete report to our federal client in a timely manner thanks to this thread.
Jun 10 '14 #20
NeoPa
32,556 Expert Mod 16PB
Posting to a dormant thread is only a problem when either :
  1. The subject matter is no longer appropriate. EG. Maybe how Access works has changed since then.
  2. An attempt is made to ask for more information - or even a separate question.
Thank you notes are never inappropriate and I suspect any members still around after this time will still appreciate the comment.
Jun 22 '14 #21
Thank you very very very much, I have solved it, by removing the Group by.
May 21 '16 #22

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

Similar topics

3
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...
2
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...
3
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...
4
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...
7
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
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...
4
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
NeoPa
by: NeoPa | last post by:
**********
2
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.