Access 2003 Memo Field Cut-off in Report

Jason.Forget

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

Subscribe Post Reply

8471

Scott Berry

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

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

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

by: euang | last post by:

Hi, I have been using access 2000 for two years on WINDOWS NT to display dynamic aweb page using ASP My ISP has now changed to Windows 2003, and I am having major problems displaying...

ASP / Active Server Pages

OleDbDataReader and MS Access Memo Field

by: Rich | last post by:

Ok I am trying to read a memo field from an Access DB that has more than 255 char. I am only getting 255 chars back from the reader. Why is this and how do i get the whole memo field. Here is a...

.NET Framework

Word Table to Access

by: Ruby Tuesday | last post by:

Hi, I was wondering if expert can give me some lite to convert my word table into access database. Note: within each cell of my word table(s), some has multi-line data in it. In addition, there...

Microsoft Access / VBA

again: datatypes Access 2003

by: mbev | last post by:

I would like to have in a field a big amount of text with a size more than 64K. This field will have text and HTML tags. Is there a way to do this in access? Ok, I may be I need to explain myself...

Microsoft Access / VBA

HELP! Web update of memo field crashes Access, errors repeatable. HELP!

by: htmlgeek | last post by:

I've beaten my head againts this for two weeks and would appreciate any help. Am running Dreamweaver 2004 MX asp pages with MS Access 2000 and then 2003 and received same problems! I've rebuilt...

Microsoft Access / VBA

Access 2003 Possible Corruption?

by: Jana | last post by:

Howdy! I have an Access 2003 SP1 where data tables reside on a server & each workstation runs the front end locally. All 5 users are on the same version of Access. We've been having problems on...

Microsoft Access / VBA

Records corrupt in Access 2000+ but not Access 97

by: Owen Jenkins | last post by:

Following on from an earlier post... I can reliably corrupt a record by doing the following ... Open two separate but identical front ends on one PC each linking to the same back end. Edit a...

Microsoft Access / VBA

Access memo field - maintaining line breaks and indents

by: cosmodango | last post by:

I have spent several days on this. I hope someone can help me. I am using Acccess 2000. I have a memo field where I have cut and pasted bulleted/numbered lists from Microsoft Word. I want to...

ASP / Active Server Pages

Memo fields clobbered (Access 2003)

by: steph | last post by:

I have a table with 250 fields. Of course you are wondering why 250 fields... what could I possibly be storing in so many fields? I am using this table as a general import table for files that...

Microsoft Access / VBA

Why can't I insert more than 255 characters into a "memo" field? (Access 2003)

by: betaphase | last post by:

I am new to Access and I'm having trouble with a database someone else created. I am wondring why I am not being able to insert more than 255 characters to a memo field in Access 2003. We need a...

Microsoft Access / VBA

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

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,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

Access 2003 Memo Field Cut-off in Report

Similar topics