Memo field being truncated

[Guest]

I am using access 2003 and a report has a memo field . The contents of the
memo field are being truncated after 255 or 256 characters even though I have
set the can grow property to yes for both the text box and the detail
section. It is not based on an underlying query or any grouping issues. I
have checked everything I can think of.

Any help would be appreciated . This is frustrating

Thanks

Tom

 

[John Spencer]

Have you applied any formatting to the control that holds the memo?

 

[Guest]

John I "inherited" this database which is what makes it difficlut. I see no
formatting in the report ( no grouping or sql statements either) and I can't
find any on the underlying query. I would gladly send you a copy to see if
you could locate the issue. I am racking my brain here!! I appreciate any
help you could give me.

Thanks so much

Tom

 

[John Spencer]

Ok, lets not resort to sending the database (or a cut-down version) yet.

Basic questions follow - I'm guessing you've already checked these, but ...

When you look at the report's record source property, what does it say.
Does it contain just the name of a Table? The name of a query? or an
actual SQL query statement?

When you look at the report's control for the memofield, is there anything
in the Format property on the Format Tab?

Is there any code attached to the report? Does any of that code (especially
in the report's open event) change the record source or manipulate the memo
field data?

 

[Guest]

John I really appreciate your help. I did check the formatting tab and there
is no formatting and as far as I can see there is no code attached to the
report. The report is based on a query called the
report_deviationexcursion_query. The Query appears to be either a cross tab
query or something similar. There arte 29 fields from 4 tables and the words
Group by in the total row. I know this means it is a totals query but the
strange thing about it is that all 29 fields have Groupby and there is no
field with sum or average or anything else.
In the field area there are expressions such as Year:
Year([devexc_date_event])

I never saw a totals query where there are no "sum" or "average" statements
somewhere. I am guessing that the problems lies in that query
:


The affected field ( the memo field ) appears like this in the query

devexc_correctiveactiontaken

i right clicked and there are no properties or formats indicated under that
property.

Maybe this will give you more information

Thanks

Tom

 

[John Spencer]

Ok, that explains why the memo field is being truncated. You can change the
GROUP BY under the MemoField to First. That will grab the first (in record
order) memo for each group.

Of course, I have no idea why someone set up the query this way.

They might have tried Distinct and found that this caused the memo field to
be truncated.

If you need all the fields and all the values , then change the query to a
standard SELECT query and see what your results look like.

John I really appreciate your help. I did check the formatting tab and
there
is no formatting and as far as I can see there is no code attached to the
report. The report is based on a query called the
report_deviationexcursion_query. The Query appears to be either a cross
tab
query or something similar. There arte 29 fields from 4 tables and the
words
Group by in the total row. I know this means it is a totals query but the
strange thing about it is that all 29 fields have Groupby and there is no
field with sum or average or anything else.
In the field area there are expressions such as Year:
Year([devexc_date_event])

I never saw a totals query where there are no "sum" or "average"
statements
somewhere. I am guessing that the problems lies in that query
:


The affected field ( the memo field ) appears like this in the query

devexc_correctiveactiontaken

i right clicked and there are no properties or formats indicated under
that
property.

Maybe this will give you more information

Thanks

Tom

John I "inherited" this database which is what makes it difficlut. I see
no
formatting in the report ( no grouping or sql statements either) and I
can't
find any on the underlying query. I would gladly send you a copy to see
if
you could locate the issue. I am racking my brain here!! I appreciate any
help you could give me.

Thanks so much

Tom

 

[Guest]

Brilliant John
Changing to a select query worked perfectly. You are a life saver!!

John I really appreciate your help. I did check the formatting tab and there
is no formatting and as far as I can see there is no code attached to the
report. The report is based on a query called the
report_deviationexcursion_query. The Query appears to be either a cross tab
query or something similar. There arte 29 fields from 4 tables and the words
Group by in the total row. I know this means it is a totals query but the
strange thing about it is that all 29 fields have Groupby and there is no
field with sum or average or anything else.
In the field area there are expressions such as Year:
Year([devexc_date_event])

I never saw a totals query where there are no "sum" or "average" statements
somewhere. I am guessing that the problems lies in that query
:


The affected field ( the memo field ) appears like this in the query

devexc_correctiveactiontaken

i right clicked and there are no properties or formats indicated under that
property.

Maybe this will give you more information

Thanks

Tom

John I "inherited" this database which is what makes it difficlut. I see no
formatting in the report ( no grouping or sql statements either) and I can't
find any on the underlying query. I would gladly send you a copy to see if
you could locate the issue. I am racking my brain here!! I appreciate any
help you could give me.

Thanks so much

Tom