By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,073 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

Access 2003 Memo Field Cut-off in Report

P: n/a
I have created a 4 Reports using the Reports Wizard in Access 2003 and
the text in a memo field is being cut off. This is an inconsistent
issue being that it is affecting just one of the reports. The field on
the report is set to Can Grow as is the Header. The total text if 697
characters. I have read the following articles and found that they do
not pertain to my issue:

http://www.mcse.ms/archive153-2004-12-1311942.html

http://support.microsoft.com/?id=288877

http://groups.google.com/group/micro...cba4f0d0394529

http://support.microsoft.com/kb/281153/en-us

I am not exporting the data and the report will be available for a set
number of individuals to access within the DB.

Any help will be greatly appriciated.

Jay

Jul 19 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Jay,

This occurs if you have Aggregated Records ('Group-By' or 'Totals' queries)
in your underlying query.

In Group By queries Memos are truncated.

Regards
Scott

<Ja**********@cox.netwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...
>I have created a 4 Reports using the Reports Wizard in Access 2003 and
the text in a memo field is being cut off. This is an inconsistent
issue being that it is affecting just one of the reports. The field on
the report is set to Can Grow as is the Header. The total text if 697
characters. I have read the following articles and found that they do
not pertain to my issue:

http://www.mcse.ms/archive153-2004-12-1311942.html

http://support.microsoft.com/?id=288877

http://groups.google.com/group/micro...cba4f0d0394529

http://support.microsoft.com/kb/281153/en-us

I am not exporting the data and the report will be available for a set
number of individuals to access within the DB.

Any help will be greatly appriciated.

Jay

Jul 20 '06 #2

P: n/a
Jay
Scott,
I read that in another article at Microsoft.com and thought it must be
the explaination, being that the text is cut off exactly at the 255th
character. I removed the Sorting & Grouping, even created a new
report, and the same issue occurs. The report is based on an SQL
statement with no sorting or grouping. Any other suggestions?

Jay
Scott Berry wrote:
Jay,

This occurs if you have Aggregated Records ('Group-By' or 'Totals' queries)
in your underlying query.

In Group By queries Memos are truncated.

Regards
Scott

<Ja**********@cox.netwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...
I have created a 4 Reports using the Reports Wizard in Access 2003 and
the text in a memo field is being cut off. This is an inconsistent
issue being that it is affecting just one of the reports. The field on
the report is set to Can Grow as is the Header. The total text if 697
characters. I have read the following articles and found that they do
not pertain to my issue:

http://www.mcse.ms/archive153-2004-12-1311942.html

http://support.microsoft.com/?id=288877

http://groups.google.com/group/micro...cba4f0d0394529

http://support.microsoft.com/kb/281153/en-us

I am not exporting the data and the report will be available for a set
number of individuals to access within the DB.

Any help will be greatly appriciated.

Jay
Jul 21 '06 #3

P: n/a
Jay
Scott,
Please disregard my last message. Due to my own ignorance I totally
misunderstood the article as well as you. Maybe I've been working too
much on the database, who knows...

Thanks for opening my eyes!

Jay
Scott Berry wrote:
Jay,

This occurs if you have Aggregated Records ('Group-By' or 'Totals' queries)
in your underlying query.

In Group By queries Memos are truncated.

Regards
Scott

<Ja**********@cox.netwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...
I have created a 4 Reports using the Reports Wizard in Access 2003 and
the text in a memo field is being cut off. This is an inconsistent
issue being that it is affecting just one of the reports. The field on
the report is set to Can Grow as is the Header. The total text if 697
characters. I have read the following articles and found that they do
not pertain to my issue:

http://www.mcse.ms/archive153-2004-12-1311942.html

http://support.microsoft.com/?id=288877

http://groups.google.com/group/micro...cba4f0d0394529

http://support.microsoft.com/kb/281153/en-us

I am not exporting the data and the report will be available for a set
number of individuals to access within the DB.

Any help will be greatly appriciated.

Jay
Jul 21 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.