Memo Field For Reports

[devdar999]

I've seen a few threads here regarding the display of memo fields in
reports and the field being truncated. Most of the solutions suggested
putting the memo in the detail of the report, which worked sometimes.
Are there any options for doing this with one of the group headers
though? It's hard to believe this is even an issue with Access? I've
been unable to get the memo to display more than 200 or so char. Yes,
grow is on for both field and report.

I don't want to use a text box because the info is variable based on
whats in the group.

Group 1
Memo 1 should display

Group 2
Memo 2 should display

Darrell

 

[Marshall Barton]

I've seen a few threads here regarding the display of memo fields in
reports and the field being truncated. Most of the solutions suggested
putting the memo in the detail of the report, which worked sometimes.
Are there any options for doing this with one of the group headers
though? It's hard to believe this is even an issue with Access? I've
been unable to get the memo to display more than 200 or so char. Yes,
grow is on for both field and report.

I don't want to use a text box because the info is variable based on
whats in the group.

Group 1
Memo 1 should display

Group 2
Memo 2 should display

Memo fields only truncate themselves when Access needs to
perform some operation that can't reasonable be done on
fields that can potentially be millions of characters long.
The most common of these is using the memo field in a
query's Group By clause or setting the text box's Format
property.

Putting the memo field's text box in a group header has
nothing to do with it (unless maybe you're grouping on the
memo field itself).

If you can't find the operation your using to cause this,
post the report's record source query's SQL statement.

 

[devdar999]

The memo field was in a group by. The report is based off of a Crosstab
query and since that automatically groups items, I'm not sure how I can
remove it? I tried using DLookup, which I've never used, but get an
error.

Table = combined_names
Field lookup = combinedname, Value = "Child Health Plus"
Output memo field = comments

=DLookUp("[comments]","[combined_names]","[combinedname] = Child Health
Plus")

 

[devdar999]

Thanks for help Marsh. I just got my DLookup to work. I think I'm ok
now.

 

[Marshall Barton]

Thanks for help Marsh. I just got my DLookup to work. I think I'm ok
now.

Great, that's the easiest way to get around your problem.
There may also be a way to use another query to join the
results of the crosstab query back to the table with the
memo field, but, without a good reason, it's not worth going
into it now.