Access Report with Sub-Report & memo field ???

[Matthew S]

I am trying to get a report, with a sub-report to work correctly. I do get
data in the subreport and memo field. HOwever the Memo field truncates the
data. I have tried having only the subreport in the details section, moved
the memo field to the footer, split it up between header/footer/detail.

One DB person in our office told me it was too complex to show all the data
that I was wanting.

So what other options are there? My boss wants all the content to show and
on one page if possible. THe memo field is the most important too. Is there
any other way of splitting it up between two pages??

Thanks,

Matt

 

[Duane Hookom]

Does the memo field always get truncated arounc 255 characters?
Does the entire value display in the report's record source datasheet view?
Are you attempting to display the memo in a group section of your report?
Have you set the Format property of the text box?
Are the controls and report sections set to allow growing?

 

[Matthew S]

Duane.

Let me try and answer those questions here:

Does the memo field always get truncated arounc 255 characters?

Yes, I am pretty sure that each record stops around 255, or the same length.
I read something about that and memo fields in reports... Not exactly sure
though.

Does the entire value display in the report's record source datasheet view?

Yes. When I run a query it shows up the entire memo field contents.

Are you attempting to display the memo in a group section of your report?

No. I have not done any grouping. I have a parameter set on a field in the
Query so that only one record set shows. SO the report has no grouping. I
have tried placing only the subreport information in the Detail Section since
it comes from a different table and kept the other fields from the 1st table
in the Header/Footer sections. I have tried moving them around in to other
places too. However I may have missed something important in that part.

Have you set the Format property of the text box?

Not sure on this one. Is that something I can do with the memo field?

Are the controls and report sections set to allow growing?

Yes. I have them checked to grown and shrink. I double checked those.

Hope that helps. THanks. Matt

 

[Duane Hookom]

A text box has a Format property. This property must be empty for memo fields.
What is the SQL view of the record source containing the memo field?


You said you weren't doing any grouping or sorting yet you state "other
fields from the 1st table in the Header/Footer sections". These can't both be
true.

 

[Matthew S]

I will look at the format property and try that.

On the grouping answer. I should have mentioned that first everything was in
the Detail section. So initially there was no grouping.

It may take a few days to get to that with my other projects going on.

Thanks,