problem to show all text (over 255 character) in a reports text bo

[Nettan]

I have problem to show all text (over 255 character) in a reports text box.

The database tables are linked SQL server tables.
A sql is created in the code when the report opens (Report_Open) and is set
as the reports RecordSource.

I tried to create a new table, in access, and copied over the text that is
not showing properly. This works.
I tried to create a new table in Sql Server and linked it to access. This
doesn't work.

So It's seems to be some problem with linked tables, anyony have any idea
how to solve this?

//Nettan

 

[Rick Brandt]

I have problem to show all text (over 255 character) in a reports
text box.

The database tables are linked SQL server tables.
A sql is created in the code when the report opens (Report_Open) and
is set as the reports RecordSource.

I tried to create a new table, in access, and copied over the text
that is not showing properly. This works.
I tried to create a new table in Sql Server and linked it to access.
This doesn't work.

So It's seems to be some problem with linked tables, anyony have any
idea how to solve this?

//Nettan

Are you saying that even if you look directly in the datasheet of the link
that the text is truncated or is it only in the report?

There are numerous things you can do in a query or report to cause fields
longer than 255 to get truncated at 255. Among them...

Using GroupBy on the field
Applying a format on the field or control
Using them to create a group section in the report.
Sorting on them

You need to first determine if it is the link, query, or report where the
truncation is occurring. I've never heard of it in a link so I expect you
will find it is your SQL or report that is doing it.

 

[Nettan]

Hi Rick, thanks for trying to help me.

It's only in the report the text is truncated.

I tried to alter the sql to only be a simple "select * from linkedTable", no
group by or sorting, but it still truncate the text.
But if I do the same with the access-table it works....

//Nettan

 

[Nettan]

Hi

Now I have tried to create a new access-file, linked the table needed and
create a report. This works!

So it seems to be a problem with my original access-file, and unfortionally
I has to use this one

//Nettan

 

[Marshall Barton]

Now I have tried to create a new access-file, linked the table needed and
create a report. This works!

So it seems to be a problem with my original access-file, and unfortionally
I has to use this one

Double check what Rick said about what you might have done
in the report to cause truncation.