Hi – I am fairly new at working with Access (using 2000) so forgive my ignorance! I have created a report that includes a memo field in the body. My problem is that when I use a query for my data, the memo field truncates even thought I have allowed it “to grow” in the format area. I have another report that uses a table for data and it prints the memo field (same one) just fine. Is there something I am doing wrong? I tried to link the original table to my query and use the memo field from the table instead of the query (hey its worth a try!) and still no luck – any help?
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Memo Fields Truncating
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Memo Fields Truncating
- This topic has 9 replies, 7 voices, and was last updated 23 years, 2 months ago.
AuthorTopicWSGail
AskWoody LoungerMarch 13, 2001 at 8:42 pm #353873Viewing 1 reply threadAuthorReplies-
WSLonnieB
AskWoody LoungerMarch 13, 2001 at 8:55 pm #518634Gail, memo fields are two part fields. Part of the field shows in the table view (or query view). The other part is stored in another area (don’t ask me where). Online help talks a little about memo fields.
The query result you get is limited to displaying about 50 or so characters in table or query view. When you open a report or form, you can see all or most of the memo field, depending on how large your fields are set on your report or form. That is why you see the whole field in the report, but not the table.
You are not doing anything wrong.
-
WSBrian Swann
AskWoody LoungerMarch 14, 2001 at 1:15 pm #518727If you want to see the entire memo field in query or table view, click in the field and type SHIFT F2 to zoom the field. But I get the feeling this isn’t really the problem you’re having is it? If you insert a memo field in a report and set CanGrow to yes it should display the entire memo field in the report regardless of the source table or query.
-
WSGail
AskWoody LoungerMarch 14, 2001 at 7:06 pm #518805 -
WSLonnie
AskWoody LoungerMarch 15, 2001 at 12:08 am #518902Gail, if it works on one report and doesn’t on the other, then the reports must have different properties. Compare both reports, at the properties level, to see what the difference is. Also, do as Brian suggests and see if the CanGrow property is turned on in the report that doesn’t work.
-
-
-
-
WSrhconley
AskWoody Lounger -
WSGail
AskWoody Lounger -
WSrhconley
AskWoody Lounger -
WSjazman2k
AskWoody LoungerMarch 8, 2002 at 2:55 pm #575173Are those report fields cutting off at a similar length, or is it just randomly truncating data?
If it’s at a similar string length, perhaps you are the victim of a memo to text conversion (with 255 as your limit)
If it’s cutting off data indescriminately:
Is the content flowing text, or do you have paragraph marks in there?just a few hunches
-
-
WSFrancois
AskWoody Lounger
-
-
Viewing 1 reply thread -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
MS Passkey
by
pmruzicka
14 minutes ago -
Can’t make Opera my default browser
by
bmeacham
2 hours, 8 minutes ago -
Do not Fall For This Purdentix Scam (Awaiting moderation)
by
elizabethkaur56
8 hours, 7 minutes ago -
*Some settings are managed by your organization
by
rlowe44
1 minute ago -
Formatting of “Forward”ed e-mails
by
Scott Mills
1 hour, 2 minutes ago -
SmartSwitch PC Updates will only be supported through the MS Store Going Forward
by
PL1
20 hours, 44 minutes ago -
CISA warns of hackers targeting critical oil infrastructure
by
Nibbled To Death By Ducks
1 day, 5 hours ago -
AI slop
by
Susan Bradley
1 day, 4 hours ago -
Chrome : Using AI with Enhanced Protection mode
by
Alex5723
1 day, 7 hours ago -
Two blank icons
by
CR2
16 hours, 35 minutes ago -
Documents, Pictures, Desktop on OneDrive in Windows 11
by
ThePhoenix
1 day, 15 hours ago -
End of 10
by
Alex5723
1 day, 18 hours ago -
Single account cannot access printer’s automatic duplex functionality
by
Bruce
16 hours, 30 minutes ago -
test post
by
gtd12345
2 days ago -
Privacy and the Real ID
by
Susan Bradley
1 day, 14 hours ago -
MS-DEFCON 2: Deferring that upgrade
by
Susan Bradley
1 day, 6 hours ago -
Cant log on to oldergeeks.Com
by
WSJonharnew
2 days, 4 hours ago -
Upgrading from Win 10
by
WSjcgc50
16 hours, 40 minutes ago -
USB webcam / microphone missing after KB5050009 update
by
WSlloydkuhnle
20 hours, 14 minutes ago -
TeleMessage, a modified Signal clone used by US government has been hacked
by
Alex5723
2 days, 20 hours ago -
The story of Windows Longhorn
by
Cybertooth
2 days, 8 hours ago -
Red x next to folder on OneDrive iPadOS
by
dmt_3904
2 days, 22 hours ago -
Are manuals extinct?
by
Susan Bradley
8 hours, 12 minutes ago -
Canonical ditching Sudo for Rust Sudo -rs starting with Ubuntu
by
Alex5723
3 days, 7 hours ago -
Network Issue
by
Casey H
2 days, 18 hours ago -
Fedora Linux is now an official WSL distro
by
Alex5723
3 days, 19 hours ago -
May 2025 Office non-Security updates
by
PKCano
3 days, 20 hours ago -
Windows 10 filehistory including onedrive folder
by
Steve Bondy
3 days, 22 hours ago -
pages print on restart (Win 11 23H2)
by
cyraxote
2 days, 22 hours ago -
Windows 11 Insider Preview build 26200.5581 released to DEV
by
joep517
4 days ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.