Memo field not displaying all the data.

[Lance McGonigal]

Hi all...Thanks in advance for your help.

I have a memo field on a report in a section header. It's only printing
about half the data. I have the can shrink and can grow property set to yes
for the memo field and the section it's in. Anyone have any ideas?

Thanks

Lance

 

[Duane Hookom]

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?

 

[Lancer]

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.

 

[Duane Hookom]

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