It does have a query where sorting and grouping is accomplished and it appears
that the memo field is being truncated to 256 characters. Is there any fix to
it as I need the grouping and sorting function?
Thanks! This is the problem....does anyone have a solution?
Dave
-----Original Message-----
From: [email protected] on behalf of Crosier, Dawn
Sent: Mon 10/10/2005 11:10 AM
To: [email protected]
Cc:
Subject: RE: [ms_access] Report functions
In addition to what Todd suggested, are you sure that the control source
of your report has all of the field in it? Memo fields can get
truncated at 256 characters if they are part of a query where sorting
and grouping is done.
Dawn Crosier
Application Specialist
"Education Lasts a Lifetime"
This message was posted to a newsgroup. Please post replies and
questions to the group so that others can learn as well.
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of Dave Moreau
Sent: Saturday, October 08, 2005 4:39 PM
To: [email protected]
Subject: [ms_access] Report functions
Why doesn't "Can Grow and Can Shrink" work when adjusting the properties
of a field that is a memo? The report is truncating the text in the
memo field for unknown reasons. I have made sure there are no other
fields in the way...only the next record in the dbase should print under
it once it has grown to include all data in the memo field.....
Unfortunately I can't get it to quit truncating the memo field in the
report....despite having the Can Grow and Can Shrink properties set to
YES.
Any ideas?
Dave
Yahoo! Groups Links
This e-mail and any attachments may be confidential or legally privileged. If
you receive this message in error or are not the intended recipient, you should
destroy the e-mail message and any attachments or copies, and you are
prohibited from retaining, distributing, disclosing or using any information
contained herein. Please inform us of the erroneous delivery by return e-mail.
Thank you for your cooperation.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
