Memo field in Rpt is truncated

[briank]

I've read several of the previous questions in this post that follow this
problem. I have a report based upon a query (that is based on another
query). Anyway, the memo field in my report is truncated to about 250
characters. However, when I view the query all of the 412 characters are
shown. I have set the "can grow" parameter in my report to yes and it does
work . . . sorta - only to 255 characters. How can I get the report field to
show all of the characters?

 

[Marshall Barton]

I've read several of the previous questions in this post that follow this
problem. I have a report based upon a query (that is based on another
query). Anyway, the memo field in my report is truncated to about 250
characters. However, when I view the query all of the 412 characters are
shown. I have set the "can grow" parameter in my report to yes and it does
work . . . sorta - only to 255 characters. How can I get the report field to
show all of the characters?

If the report's record source query displays all the
characters, then check the text box's Format property and
make sure it is blank.

 

[briank]

I've checked the format property and it is blank. Any other thoughts?

 

[Marshall Barton]

Other than the query truncation, that's the only cause I've
ever run into.

I'm out of ideas, but, if you ever do find out the cause, I
sure would like to know what it is.

 

[briank]

I am trying a different route. Instead of using the memo field (which isn't
working) I am trying to use the DLookup command. This may be the way to go
but I am having a bug. Perhaps you can help.

I am using the following:
=DLookUp("LastOfLastOfcomments","qryAcqStatus","Parcel=[Parcel]")

This works only if the underlying query is modified to return only one
record. If I take out this criteria then the report is based upon 200
records and returns a null. Any thoughts?

Other than the query truncation, that's the only cause I've
ever run into.

I'm out of ideas, but, if you ever do find out the cause, I
sure would like to know what it is.
--
Marsh
MVP [MS Access]

I've checked the format property and it is blank. Any other thoughts?

 

[Marshall Barton]

The where part of the DLookup should be:

"Parcel=" & [Parcel]

Normally, when using a DLookup to retrieve a memo field like
this, you should remove it from the query and go directly to
its table.
--
Marsh
MVP [MS Access]

I am trying a different route. Instead of using the memo field (which isn't
working) I am trying to use the DLookup command. This may be the way to go
but I am having a bug. Perhaps you can help.

I am using the following:
=DLookUp("LastOfLastOfcomments","qryAcqStatus","Parcel=[Parcel]")

This works only if the underlying query is modified to return only one
record. If I take out this criteria then the report is based upon 200
records and returns a null. Any thoughts?

Other than the query truncation, that's the only cause I've
ever run into.

I'm out of ideas, but, if you ever do find out the cause, I
sure would like to know what it is.