Full memo field data not displayed in report

A

Andy

I'm using Access 2002, and find that a memo
field "Problem" takes in data greater than 255 characters
in length, but when this field is used as the basis of a
report, the report truncates the field to a max of 255
characters.

Any ideas?

Thanks,

Andy
 
K

Ken Snell [MVP]

Is the report's Record Source a query that is a "totals" query? And is the
memo field part of the GROUP BY clause?

Or is the memo field part of the query's ORDER BY clause? If yes, this will
cause truncation of the memo field's value because Jet will use just the
first 255 characters for the sorting.

Post the SQL of the report's record source query and identify the fields.

Also, check that the Can Grow property of the textbox control that is bound
to the memo field is set to Yes (this assumes that the textbox is in the
Detail section of the report).
 
A

andrewlenczycki

Ken,

I don't believe the query is a "totals" query, but the
WorkDone field is part of the GROUP BY clause. It is not
part of the ORDER BY clause.

I do have the Can Grow property of the textbox control
that is bound to the memo field set to Yes.

The SQL is as follows:

SELECT [Service Orders].OrderNo, [Service
Orders].Received, [Service Orders].TakenBy, [Service
Orders].Tenant, [Service Orders].AptNo, [Service
Orders].Phone, [Service Orders].Permission, [Service
Orders].Problem, [Service Orders].Priority, [Service
Orders].CompleteDate, [Service Orders].Parts, [Service
Orders].Labor, [Service Orders].Contractor, [Service
Orders].WorkDone, [Service Orders].Satisfied, [Service
Orders].CompletedBy
FROM [Service Orders]
GROUP BY [Service Orders].OrderNo, [Service
Orders].Received, [Service Orders].TakenBy, [Service
Orders].Tenant, [Service Orders].AptNo, [Service
Orders].Phone, [Service Orders].Permission, [Service
Orders].Problem, [Service Orders].Priority, [Service
Orders].CompleteDate, [Service Orders].Parts, [Service
Orders].Labor, [Service Orders].Contractor, [Service
Orders].WorkDone, [Service Orders].Satisfied, [Service
Orders].CompletedBy
HAVING ((([Service Orders].OrderNo)=[What Service Order
Number?]))
ORDER BY [Service Orders].OrderNo;

thanks,

Andy
 
K

Ken Snell [MVP]

This is a "totals" query. Such queries use the GROUP BY clause.

Instead of including the memo field as part of the GROUP BY clause, use the
First aggregate function for it:

SELECT [Service Orders].OrderNo, [Service
Orders].Received, [Service Orders].TakenBy, [Service
Orders].Tenant, [Service Orders].AptNo, [Service
Orders].Phone, [Service Orders].Permission, [Service
Orders].Problem, [Service Orders].Priority, [Service
Orders].CompleteDate, [Service Orders].Parts, [Service
Orders].Labor, [Service Orders].Contractor, First([Service
Orders].WorkDone), [Service Orders].Satisfied, [Service
Orders].CompletedBy
FROM [Service Orders]
GROUP BY [Service Orders].OrderNo, [Service
Orders].Received, [Service Orders].TakenBy, [Service
Orders].Tenant, [Service Orders].AptNo, [Service
Orders].Phone, [Service Orders].Permission, [Service
Orders].Problem, [Service Orders].Priority, [Service
Orders].CompleteDate, [Service Orders].Parts, [Service
Orders].Labor, [Service Orders].Contractor,
[Service Orders].Satisfied, [Service
Orders].CompletedBy
HAVING ((([Service Orders].OrderNo)=[What Service Order
Number?]))
ORDER BY [Service Orders].OrderNo;
--

Ken Snell
<MS ACCESS MVP>

[email protected] said:
Ken,

I don't believe the query is a "totals" query, but the
WorkDone field is part of the GROUP BY clause. It is not
part of the ORDER BY clause.

I do have the Can Grow property of the textbox control
that is bound to the memo field set to Yes.

The SQL is as follows:

SELECT [Service Orders].OrderNo, [Service
Orders].Received, [Service Orders].TakenBy, [Service
Orders].Tenant, [Service Orders].AptNo, [Service
Orders].Phone, [Service Orders].Permission, [Service
Orders].Problem, [Service Orders].Priority, [Service
Orders].CompleteDate, [Service Orders].Parts, [Service
Orders].Labor, [Service Orders].Contractor, [Service
Orders].WorkDone, [Service Orders].Satisfied, [Service
Orders].CompletedBy
FROM [Service Orders]
GROUP BY [Service Orders].OrderNo, [Service
Orders].Received, [Service Orders].TakenBy, [Service
Orders].Tenant, [Service Orders].AptNo, [Service
Orders].Phone, [Service Orders].Permission, [Service
Orders].Problem, [Service Orders].Priority, [Service
Orders].CompleteDate, [Service Orders].Parts, [Service
Orders].Labor, [Service Orders].Contractor, [Service
Orders].WorkDone, [Service Orders].Satisfied, [Service
Orders].CompletedBy
HAVING ((([Service Orders].OrderNo)=[What Service Order
Number?]))
ORDER BY [Service Orders].OrderNo;

thanks,

Andy
-----Original Message-----
Is the report's Record Source a query that is a "totals" query? And is the
memo field part of the GROUP BY clause?

Or is the memo field part of the query's ORDER BY clause? If yes, this will
cause truncation of the memo field's value because Jet will use just the
first 255 characters for the sorting.

Post the SQL of the report's record source query and identify the fields.

Also, check that the Can Grow property of the textbox control that is bound
to the memo field is set to Yes (this assumes that the textbox is in the
Detail section of the report).

--

Ken Snell
<MS ACCESS MVP>





.
Click to expand...
Click to expand...
 
Top