Duane Hookom, Thank You!

[Lancer]

Well the thing is truncated. I moved the report around a little bit and
that help things. I never thought of the NZ() instead of the IIF. That's
pretty slick.

Thanks for taking my note.

Lance

3. A header or footer is basically a Group By query and memo fields may get
truncated in a query if you use Group By. A test in Access 2002 didn't get
truncated. You could try a subreport of just the memo field to replace the
text box. Use the Link Master/Child properties to join the correct record in
the subreport.

Also,
=IIF(isnull([memo1]),[memo2],[memo1])
can possibly be replace by
=Nz([memo1],[memo2])

--
Duane Hookom
MS Access MVP

Duane...

Thanks for taking my note. Here are the responses to your question:

1. Yes, I can see all the data in the underlying query to the report.
2. The field is an expression so it won't let me set the format. The
expression is basically the following:

MySummary: IIF(isnull([memo1]),[memo2],[memo1])

Both memo1 & 2 are memo type field in the table.

3. I can see all the data when I move it to the detail field. What gives?

Thanks.

First, do you see all the data in the report's record source datasheet view?
Do you have any format property set on the text box?
What happens if you move the text box to the detail section?

--
Duane Hookom
MS Access MVP


to
yes