text field truncated after 255 char in a footer

[jpgol]

Hi,

I have a report based on a query. In that query there is a field containing > 255 char. I want to use that field in a report, on a sorting and grouping section.
However the field is truncated at 255 char.
Thefield is completely shown in the page footer, but this is not the plce I want it in.

Can any one help?

Kind regards,
JP

 

[vbaInet]

Is this a memo field?

Welcome to AWF by the way

 

[jpgol]

Thanks,
Not specific a memo field. Is this necessary. if yes, how can I change it into a memo field.

 

[vbaInet]

Truncation normally happens with memo fields. I think it's the sorting & grouping that is causing the output to be truncated. Don't sort or group on a column with more than 255 chars. You could however, sort and group if you create an aliased field from that field and sort by the first 127 chars, using Left() and Len().

Or try using FIRST in the query instead of GROUP BY.

 

[boblarson]

1. If it is truncated after 255 characters then this IS a memo data type. Text fields are limited to 255 characters.

2. You need to create a separate query for ALL fields EXCEPT the memo field. Any criteria should be based on that query.

3. Then you create a query with ONLY the ID field and the memo field (NO CRITERIA ON ANY FIELD) and save it.

4. You can then join the two queries together by the ID field in a third query and then you should get all of the memo field text.

 

[jpgol]

It is indeed the sorting and grouping that is causing the problem, however I group on another field and not on the text field I want to show.
Also the seperate query doesn't help.

Any other suggestions?

 

[boblarson]

I would need to see a copy of the database to see if I can get it to work.

 

[jpgol]

That's not so easy, beacause the MS access database queries out of a Sybase database (ODBC) with multiple table (>10). I can get you the mdb.

 

[boblarson]

which tables does the memo field come out of? Also you can do an import from the sybase tables (but use the Import table specification only) without data.

We can see if that will be helpful. It may not, but then again...